This article describes the differences between the ALL and CROSSFILTERED functions in DAX. ALL CALCULATE modifier Returns all the rows in a table, or all the values in a column, ignoring any filters that might have been applied. ALL (… Read more
This article describes how to optimize inventory calculations in DAX by using snapshots to avoid the computational cost of a complete running total. Read more
This article explores the implications of having blank values in date columns and provides the best practices for managing them in DAX calculations and Power BI reports. Read more
This article describes the use of visual calculations for a scenario where they may be particularly relevant: computing open orders at the end of a time period. Read more