Forum Discussion
Calculating Percentage
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
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,
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