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! The requirement is to get the total number of accounts as of the month. So what I did is I created a measure that gets the cumulative value. However, looking at the sum, it didn't add up all the values. Anyone can help me on this please?
@Anonymous
Can you share the dax of your measures?
As suggested by @v-danhe-msft , the sumx will help you get to your answer but would depend on how your measure is written
Thanks
Hello,
I tried the measure but it didnt work.
Here's my measure:
Hi @Anonymous ,
You could try to with HASONEVALUE function or ISFILTERED function to calculated your data, below links that may have the same problem with you:
https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376
https://community.powerbi.com/t5/Desktop/Measure-Total-not-correct/td-p/495362
If it still could not help you, I suggest you offer your pbix file that I could test for you.
Regards,
Daniel He
Hi @Anonymous ,
Based on my test, you could use SUMX function to solve your problem:
[Measure] is your running total measure
Create below measure:
Measure 2 = SUMX('Table1',[Measure])
Result:
Regards,
Daniel He
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |