The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
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 |
---|---|
141 | |
109 | |
108 | |
76 | |
63 |
User | Count |
---|---|
270 | |
129 | |
123 | |
100 | |
92 |