Forum Discussion
Level of Detail Calcs
Yes, in Power BI this is done through DAX filter expressions combined with measures, for example:
= CALCULATE( SUM('ResellerSales_USD'[SalesAmount_USD]),ALL('ResellerSales_USD'))A measure defined this way would give you the SUM of [SalesAmount_USD] regardless of any visual-level filters/selections. There are a number of these types of filter functions, ALL, ALLEXCEPT, etc.
Community ChampionYes, in Power BI this is done through DAX filter expressions combined with measures, for example:
= CALCULATE( SUM('ResellerSales_USD'[SalesAmount_USD]),ALL('ResellerSales_USD'))
A measure defined this way would give you the SUM of [SalesAmount_USD] regardless of any visual-level filters/selections. There are a number of these types of filter functions, ALL, ALLEXCEPT, etc.
I am not sure if you ever used tableau but the formula I would use is { FIXED [ItemLoc],[Period]: SUM([ActualDemand UNITS ])}. How do I translate this into a Dax function? I tried =calculate(sum( vdemand[actual demand Units], Vdemand[ItemLocation], vdemand[period]) but recieve an error that itemlocation cannot be turned into a true or false statement.
SeanBmsams you have to specify the filter conditions - let me know if this helps
= CALCULATE ( SUM(vdemand[actual demand Units]), vdemand[ItemLocation]="USA", vdemand[period]=2015)
SatyaVaitlaAdvocate II
LOD allows me to specify level of a hierarchy. For example, when the sum is shown at country level, we can define whether the sum to be from state level or city level. i.e we specify country as parameter instead of a specific country name like USA for filtering. So LOD is more than filtering and controls from which level to sum up in a hierarchy. Pl help me showing the relevant DAX
