Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi guys,
I have an issue that drives me crazy. I'm using a complex formula that uses SUMX and also USERELATIONSHIP in order to achieve my final measure, that produces the output like in column 1 in my screenshot. Now when I do the MROUND on that calculation it does the MROUND on every level, so I get the output of column 3 while I need the output of column 2:
So instead of the MROUND to round 744 to 745 I need it to sum the rounded values of the levels bellow (375+170+105+75+25 = 750).
Can you let me know what could be the issue?
The Price measure I'm using is the one bellow, and the base measure is just a simple sum:
Solved! Go to Solution.
Hi @wildrose2023 ,
I created some data:
Here are the steps you can follow:
1. Create measure.
Test =
IF(
ISINSCOPE('DimIssue'[Account]),[Price],ROUND(SUMX(VALUES('DimIssue'[Account]),[Price]),-1))
2. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi @wildrose2023 ,
I created some data:
Here are the steps you can follow:
1. Create measure.
Test =
IF(
ISINSCOPE('DimIssue'[Account]),[Price],ROUND(SUMX(VALUES('DimIssue'[Account]),[Price]),-1))
2. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
33 | |
16 | |
13 | |
10 | |
8 |
User | Count |
---|---|
59 | |
20 | |
12 | |
11 | |
10 |