Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi,
I wrote a measure which was giving the result correct at last level but when I drill up the numbers/total is not coming correct. Can someone please help to resolve it.
I am attching the pbix file with the measure and the sample data.
Here is the PBIX file Link
https://drive.google.com/file/d/1a1yRBN06B86j4L-AoNruRpMmvjg6yWZv/view?usp=share_link
@Amit
Solved! Go to Solution.
HI @redsailbi,
It seems like a common measure total issue when it tries to apply multiple level aggregation to the expression. I'd like to suggest you refer to Greg’s blog to know how to handle with this scenario:
Measure Totals, The Final Word
Notice: add a variable with SUMMARIZE function to calculate hit the first level aggregate, then use iterator function to apply the second level on the variable with calculated records from previous step.
Regards,
Xiaoxin Sheng
HI @redsailbi,
It seems like a common measure total issue when it tries to apply multiple level aggregation to the expression. I'd like to suggest you refer to Greg’s blog to know how to handle with this scenario:
Measure Totals, The Final Word
Notice: add a variable with SUMMARIZE function to calculate hit the first level aggregate, then use iterator function to apply the second level on the variable with calculated records from previous step.
Regards,
Xiaoxin Sheng
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
14 | |
2 | |
1 | |
1 | |
1 |
User | Count |
---|---|
10 | |
3 | |
3 | |
3 | |
2 |