Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
User | Count |
---|---|
140 | |
113 | |
104 | |
76 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |