Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
User | Count |
---|---|
58 | |
21 | |
18 | |
16 | |
12 |
User | Count |
---|---|
85 | |
54 | |
39 | |
21 | |
18 |