Forum Discussion
th340385
2 years agoHelper I
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...
- 2 years ago
PBI file attached.
Hope this helps.
Ashish_Mathur
2 years agoSuper User
Hi,
This works for me
C = COUNTA(Data[Stage])Measure = CALCULATE([C],FILTER(ALL(Data[Stage]),Data[Stage]>=MIN(Data[Stage])))
th340385
2 years agoHelper I
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 |
- Ashish_Mathur2 years agoSuper User
PBI file attached.
Hope this helps.
- th3403852 years agoHelper I
This was perfect! Thank you!
- Ashish_Mathur2 years agoSuper User
You are welcome.