Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi, I have the following problem: I have used the following measure to calculate the cumulative sum:
This should be the sum of entries in the table:
mit IV = DISTINCTCOUNT(Kunde[amsidnr])
IV = CALCULATE ( KUNDE[mit IV]; FILTER( ALL(KUNDE[INSERTDATE].[Date]); KUNDE[INSERTDATE].[Date] <= MAX(KUNDE[INSERTDATE].[Date])))
Solved! Go to Solution.
Hi @Anonymous,
This measure should work.
IV = CALCULATE ( KUNDE[mit IV], FILTER( ALLSELECTED(KUNDE), KUNDE[INSERTDATE] <= MAX(KUNDE[INSERTDATE]) ))
Best regards,
Yuliana Gu
@AlB Thanks for the help!
I have a Table called KUNDE with the following columns:
amsidnr : a distinct number assigned to each customer
INSERTDATE : the date when the new customer was added to the table
mit IV : number of different amsidnr in the table
IV : cumulative sum of mit IV over time INSERTDATE
I managed to solve he issue temporarily by setting boundaries to my x-axis, but i don`t want to update those boundaries every day. Without them the visualization would show me data for all the months of 2019.
User | Count |
---|---|
128 | |
108 | |
100 | |
64 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |