Forum Discussion

Anonymous

Not applicable

8 years ago

Solved

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

Anonymous
8 years ago
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

Not applicable

8 years ago

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

Not applicable

8 years ago

Hi Anonymous

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

Anonymous
Not applicable
8 years ago
Hi Anonymous,

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

Best Regards,
L.Meijdam
- Anonymous
  Not applicable
  8 years ago
  actually, it's dimmed!
- Anonymous
  Not applicable
  8 years ago
  Hi Anonymous
  
  Thank you very much for your helpful replies.
  - Anonymous
    Not applicable
    8 years ago
    Anonymous,
    
    You're welcome, glad I could help :)
    
    Best Regards,
    L.Meijdam

Related content