Dax Measure Help

[th340385]

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

[Ashish_Mathur]

Hi,

Share the download link of the PBI file.

[th340385]

Unfortunately I am not able to provide same data. However, it is a very simple table with only two fields.  I think the first part of my measure is working correctly, but I want to aggregate the result even further as shown below:

[Ashish_Mathur]

I will need some file to work with.

[th340385]

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: 

[Ashish_Mathur]

Hi,

This works for me

C = COUNTA(Data[Stage])

Measure = CALCULATE([C],FILTER(ALL(Data[Stage]),Data[Stage]>=MIN(Data[Stage])))

[th340385]

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_Mathur · Accepted solution]

PBI file attached.

Hope this helps.

[th340385]

This was perfect! Thank you!

[Ashish_Mathur]

You are welcome.

[lbendlin]

I cannot assist you if you are unable to provide sample data. I hope someone else can help you further.

[th340385]

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: 

[lbendlin]

please provide the definition for [Count All Rows]

[th340385]

[Count All Rows] is just a measure that counts all rows of the 'data' table. 

Count All Rows = COUNTROWS('Data')

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

[th340385]

Unfortunately I am not able to provide same data. However, it is a very simple table with only two fields.  I think the first part of my measure is working correctly, but I want to aggregate the result even further as shown below: