Create a card or measure for the number of status

[Larry_Wang]

Hi Everyone,

I want to create a measure or a card that can show the number of items for each status. See picture below for details. For example I want to know how many closed or resolved items. How to do this? I tried to work with new quick measure but not succeed. Can anyone give me some good suggestions on this issue? Thanks a lot🙂

Thanks,

Larry

[PhilipTreacy]

Hi @Larry_Wang 

Please check my updated post and sample file which includes separate cardsd and measures for Closed and Resolved.

https://d13ot9o61jdzpp.cloudfront.net/files/pbiforum/Larry_Wang1.pbix

regards

Phil

[PhilipTreacy · Accepted solution]

Hi @Larry_Wang 

Download this sample PBIX file with the following data and DAX measure

Try these measures

Closed = CALCULATE( COUNTA('StatusTable'[Status]), FILTER('StatusTable', 'StatusTable'[Status] = "Closed"))

Resolved = CALCULATE( COUNTA('StatusTable'[Status]), FILTER('StatusTable', 'StatusTable'[Status] = "Resolved"))

With this table

Gives this

Regards

Phil

[Larry_Wang]

Hi @PhilipTreacy ,

Cool! It is exactly what I want. Thank you for the help on this issue.

Larry

[Larry_Wang]

Hi @PhilipTreacy ,

I tried to create this measure but it returns a value for the total number of all status types. How can I set a filter like "Closed" to this measure so that it only calculate "Closed" items?

Thanks,

Larry