Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hey Guys,
For those familiar with Tableau.....does Power BI have a way to do level of detail calculations?
http://www.tableau.com/LOD-expressions.
Any help would be appreciated.
Thanks,
Joe
Solved! Go to Solution.
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.
Dealing with information at different granularites will require a specific data model, have a look here - http://www.cimaglobal.com/en-gb/Thought-leadership/Newsletters/Insight-e-magazine/Insight-2012/Insig...
Would be useful to see how your data mosel is set up in order to address your original query, can you post a screenshot?
Are these numbers supposed to add up somehow?
Thanks for prompt response and the answer is No
When fully distributed,each level will be the sum of the lower level for every hierarchy. But most of the times, we keep always some cushion at every level for future distribution. so the numbers will never add up to the higher level. Only during end of the project the lower level may add up to the next higher level.
But that is something which can happen but should not be assumed. The drill down should display the related budget for that level only with out considering the lower level.
The real complexity comes when i add one more measure - my actual costs. Because actual costs will have many line items for every budget line, there will be challenge when we need to show budget vs actual in drill down graph. Actual costs also can happen at every level of hierarchy. For example my costs can be at project level or at 1level node or 2nd level node or at any level.
I hope my requirement is clear now and look forward for power BI solution.
Regards
Satya
Satya,
I'm having the same challenge, "how to do a Level of Detail (LOD-Tableau) calculation within Power BI?"
Were you able to understand how to go about doing this in DAX?
Thank you
Brad