Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Dears,
I am new in Power BI and I need to calculate percentage of "Open" status but I don't know how
your help is highly appreciated
Solved! Go to Solution.
Hi @Anonymous,
I think you can do it like this:
Create a measure:
CountOpen = CALCULATE(COUNTA(Table1[Status]);Table1[Status] = "Open")
and after that:
PercentageOpen = [Countopen] / COUNT(Table1[Status])
The last measure will give you the percentage of Open status'es, you need to format the last measure as percentage!
If you want to do the same for Closed you can do it the same way but replace "Open" by "Closed"
Let me know if this worked. 🙂
Regards,
L.Meijdam
Hi @Anonymous,
I think you can do it like this:
Create a measure:
CountOpen = CALCULATE(COUNTA(Table1[Status]);Table1[Status] = "Open")
and after that:
PercentageOpen = [Countopen] / COUNT(Table1[Status])
The last measure will give you the percentage of Open status'es, you need to format the last measure as percentage!
If you want to do the same for Closed you can do it the same way but replace "Open" by "Closed"
Let me know if this worked. 🙂
Regards,
L.Meijdam
Hi @Anonymous,
What happens when you display the first measure in a card visual ?
Best regards,
L.Meijdam
@Anonymous
This is what happens
Hi @Anonymous,
- Are you sure you named your measure "CountOpen" ? it is case sensitive
- is "CountOpen" Formatted as a whole number ?
Best Regards,
L.Meijdam
Hi @Anonymous
Thank you brother, it's working now, but I need to be in percentage format
Hi @Anonymous,
You can select your measure and after that click on the button in the picture below:
Best Regards,
L.Meijdam
Hi @Anonymous
Thank you very much for your helpful replies.
@Anonymous,
You're welcome, glad I could help 🙂
Best Regards,
L.Meijdam
actually, it's dimmed!
Hi @Anonymous
How to format it as a whole No.?
It's working and shows the No. of Open status
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
106 | |
105 | |
86 | |
72 |