Calculating Percentage

[Anonymous]

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

[Anonymous · Accepted 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

[Anonymous]

Hi L. Meijdam

I created the 1st measure as you described, but when I tried to create the Second one it gives me the message below:

The value for 'countopen' cannot be determined. Either 'countopen' doesn't exist, or there is no current row for a column named 'countopen

[Anonymous]

Hi @Anonymous,

What happens when you display the first measure in a card visual ? 

Best regards,

L.Meijdam

[Anonymous]

@Anonymous

This is what happens

[Anonymous]

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

[Anonymous]

Hi @Anonymous

Thank you brother, it's working now, but I need to be in percentage format

[Anonymous]

Hi @Anonymous,

You can select your measure and after that click on the button in the picture below:

Best Regards,

L.Meijdam

[Anonymous]

Hi @Anonymous

Thank you very much for your helpful replies. 

[Anonymous]

@Anonymous,

You're welcome, glad I could help 🙂

Best Regards,

L.Meijdam

[Anonymous]

actually, it's dimmed!

[Anonymous]

Hi @Anonymous

How to format it as a whole No.?

[Anonymous]

It's working and shows the No. of Open status