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(ALLSELECTED('Data'), 'Data'[Stage#] >= max('Data'[Stage#]))) Current Output: Stage #1234567# of rows in stage 22,543 21,749 21,351 14,379 7,407 6,088 5,466 This measure calculates the correct number of rows for each stage; however, I was hoping to have cumulative number of rows greater than or equal to each stage. Desired result is below: Stage #1234567# of rows in stage 98,983 76,440 54,691 33,340 18,961 11,554 5,466

PBI file attached. Hope this helps.

th340385

Helper I

2 years ago

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(ALLSELECTED('Data'), 'Data'[Stage#] >= max('Data'[Stage#])))

Current Output:

Stage #	1	2	3	4	5	6	7
# of rows in stage	22,543	21,749	21,351	14,379	7,407	6,088	5,466

This measure calculates the correct number of rows for each stage; however, I was hoping to have cumulative number of rows greater than or equal to each stage.

Desired result is below:

Stage #	1	2	3	4	5	6	7
# of rows in stage	98,983	76,440	54,691	33,340	18,961	11,554	5,466

Need Help

Ashish_Mathur
2 years ago
PBI file attached.

Hope this helps.

Accumulate.pbix45 KB

Forum Discussion

Dax Measure Help