The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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
Solved! Go to 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
Proud to be a Super User!
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
Proud to be a Super User!
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
Proud to be a Super User!
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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
126 | |
107 | |
87 | |
65 | |
60 |
User | Count |
---|---|
257 | |
121 | |
117 | |
100 | |
79 |