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.
Hello all,
Would you be so kind and help me out with measures that comes out of opening balance?
Sum of measure out of opening balance aren't correct
Sum of Measure 1 is showing in PBI 28.20 however it should be 35.00
Sum of Measure 2 is showing in PBI 57,750.00 however it should be 72,916.67
Sum of Measure 3 is showing in PBI 3,525.00 however it should be 4,375
Here is my pbix : https://ulozto.cz/tamhle/09aKv8imMdia/name/Nahrano-17-2-2021-v-16-26-19
Many thanks in advance.
Kind regards.
Andrej
Solved! Go to Solution.
Try to build three new measures as below.
New_Measure1 = SUMX(MonthTable,[Measure 1])
New_Measure2 = SUMX(MonthTable,[Measure 2])
New_Measure3 = SUMX(MonthTable,[Measure 3])
Result is as below.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Try to build three new measures as below.
New_Measure1 = SUMX(MonthTable,[Measure 1])
New_Measure2 = SUMX(MonthTable,[Measure 2])
New_Measure3 = SUMX(MonthTable,[Measure 3])
Result is as below.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 |
---|---|
112 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |