Forum Discussion
Solved
Dax Measure Help
Hello, I have a dataset that I am trying to calculate the total number of rows >= a specific stage number. My current measure is: Count by Stage = CALCULATE([Count All Rows], FILTER(ALLSE...
PBI file attached.
Hope this helps.
I will need some file to work with.
| Stage |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 2 |
| 2 |
| 2 |
| 3 |
| 3 |
The table above is very simple sample data that can be used in a pbix file. See below for updated screenshot of current measure and desired result using the sample data:
Hi,
This works for me
C = COUNTA(Data[Stage])Measure = CALCULATE([C],FILTER(ALL(Data[Stage]),Data[Stage]>=MIN(Data[Stage])))Thank you, but I am able to get that measure to work. I am trying to get step two (see below). I would like to see the cummulative count at each stage.
Stage # 1 2 3 Cummulative # 17 7 2 PBI file attached.
Hope this helps.