Forum Discussion
Cumulative Percent
I am trying to do a parento chart in Power BI and all of the guides I find seem very complicated. Can I just create a new measure where I calculate the cumulative percentage and insert that measure a...
Looks like you've missed a parens.
CumulativeCount = CALCULATE([CountMeasure],FILTER(ALL('Table1'), 'Table1'[Referral Date] <= MAX('Table1'[Referral Date]) ))It's helpful if you tell us what error you're getting, or if you're getting an unexpected result when you say that a measure isn't working
Ok, so for the ordering logic, I want to sort it by the Referral date.
I have the rest of the dashboard already grouped by date, so I was unsure if I had to include it in the logic. So I have to put the filter in for my CumulativeCount equation?
My logic isn't working
CumulativeCount = CALCULATE([CountMeasure],FILTER(ALL('Table1', 'Table1'[Referral Date] <= MAX('Table1'[Referral Date])))
Looks like you've missed a parens.
CumulativeCount = CALCULATE([CountMeasure],FILTER(ALL('Table1'), 'Table1'[Referral Date] <= MAX('Table1'[Referral Date]) ))It's helpful if you tell us what error you're getting, or if you're getting an unexpected result when you say that a measure isn't working