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

12 Replies

Anonymous
Not applicable
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 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
    Not applicable
    8 years ago
    Hi Anonymous,
    
    What happens when you display the first measure in a card visual ?
    
    Best regards,
    L.Meijdam

Related content