Create measure based on calculated status column

[DairyG1]

Hello All,

Hope i can get your expert help.

I have a calculated column with two statuses - Pass & Fail

I want to show the percentage of Pass items within a card.

Can someone guide me on this please?

Thank you

[PijushRoy · Accepted solution]

Hi @DairyG1 

Please use 

Pass% = Divide(
Calculate(Count(PassFailCouln),PassFailCouln="Pass"),
Count(PassFailCouln))

Change the datatype of the measure as Percentage

[DairyG1]

@PijushRoy - Thank you that worked great, much appreciated for the support

[Idrissshatila]

Hello @DairyG1 ,

so what you can do is count all the rows and count rows with specific statuse and then divide the counted rows with each status with the all rows.

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin

[DairyG1]

@Idrissshatila - thanks but can you elborate on how that would be written please