Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi, guys,
I have found a very strange calculation Percentage between the measure and Calculation Group.
I expected to see the same calculations using filter modifiers in Calculation Group.
I could not find any answer in your book about this feature in calculation group.
Can you help me?Is it a Bug?
And if I add the measure Sales% under the action of the calculation group, then the calculations become the same.
How one measure can influence to another measure?It is magic.
The dataset is here:https://fex.net/s/9rpnlb0
Hi again @denis_shumilin
I have tried to isolate the conditions required to reproduce this bug, so I created a very simple PBIX to demonstrate the issue (attached).
To reproduce this apparent bug, I believe these are the requirements:
The bug can be avoided by removing any of the above conditions, for example:
Does this sound right?
I intend to raise this as an issue. Let me know if you have any other thoughts 🙂
My takeway at the moment is that it is risky to use ALLSELECTED () within calculation items.
Regards
I ran into this bug just today and I can confirm that as of April 2024, it is still not fixed. The good news is that @OwenAuger's workaround also still works.
Very nasty issue that silently produces incorrect numbers.
Thank you, very interesting solution for avoiding the bug.
Thanks for posting! This is puzzling and certainly looks like a bug at first glance.
I agree that we should expect the same result for (1) the measure with calc item applied, and (2) the measure with equivalent code.
Also, the presence of an additional shouldn't make a difference, but it does!
I'm keen to test further and will post back.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
42 | |
21 | |
21 | |
14 | |
14 |
User | Count |
---|---|
43 | |
39 | |
33 | |
18 | |
17 |