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.
I have Date and Feature coming from a source and need to add a Cumulative row count until that date and for that feature
I added sample values for the cumulative count
If I only have one feature , the following formula gives the count fine
CumulativeCount = CALCULATE(COUNTROWS(Registrations), FILTER (ALL(Registrations), [ApprovedDate] <= MAX([ApprovedDate])))
How to add one more filter to count only rows of Feature value in the current row context?
Solved! Go to Solution.
ALLEXCEPT helps in doing such calculations for sub categories.
Try this
CumulativeCount = CALCULATE ( COUNTROWS ( Registrations ), FILTER ( ALLEXCEPT ( Registrations, Registrations[Feature] ), [Date] <= MAX ( [Date] ) ) )
To achieve your requirement, you can add VALUES() at the end of your expression. Please refer:
CumulativeCount = CALCULATE ( COUNTROWS ( Registrations ), FILTER ( ALL ( Registrations ), [ApprovedDate] <= MAX ( [ApprovedDate] ) ), VALUES ( Registrations[Feature] ) )
Thanks,
Xi Jin.
To achieve your requirement, you can add VALUES() at the end of your expression. Please refer:
CumulativeCount = CALCULATE ( COUNTROWS ( Registrations ), FILTER ( ALL ( Registrations ), [ApprovedDate] <= MAX ( [ApprovedDate] ) ), VALUES ( Registrations[Feature] ) )
Thanks,
Xi Jin.
ALLEXCEPT helps in doing such calculations for sub categories.
Try this
CumulativeCount = CALCULATE ( COUNTROWS ( Registrations ), FILTER ( ALLEXCEPT ( Registrations, Registrations[Feature] ), [Date] <= MAX ( [Date] ) ) )
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 |
---|---|
110 | |
99 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |