Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have a table of transactions with a transaction date. I want to create a line graph that displays the cumulative count of transactions.
I created a new column as:
Cumulative Count = CALCULATE( COUNTROWS(master_roster), FILTER( ALLSELECTED(master_roster), master_roster[enrollmentDate] <= MAX(master_roster[enrollmentDate]) ) )
For some reason, the filter does not seem to be working. Every data row in the table has Cumulative Count = the total number of rows. When I create a line graph with [enrollmentDate] on the Axis and Maximum of [Cumulative Count] in the values I get the total count for all dates.
What am I doing wrong?
Solved! Go to Solution.
Hi,
If you are using a calculated column, you need to replace "Max" with "Earlier"
= CALCULATE ( COUNTROWS ( master_roster ), FILTER ( master_roster, master_roster[enrollmentDate] <= EARLIER ( master_roster[enrollmentDate] ) ) )
Hi @pmcard97,
Show your dataset and the expected result.
Hi,
If you are using a calculated column, you need to replace "Max" with "Earlier"
= CALCULATE ( COUNTROWS ( master_roster ), FILTER ( master_roster, master_roster[enrollmentDate] <= EARLIER ( master_roster[enrollmentDate] ) ) )