Forum Discussion

DairyG1's avatar
DairyG1
Helper I
3 years ago
Solved

Create measure based on calculated status column

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 ...
Need Help
  • PijushRoy's avatar
    PijushRoy
    3 years ago

    Hi DairyG1 

    Please use 

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

     

    Change the datatype of the measure as Percentage

PijushRoy's avatar
PijushRoy
Community Champion
3 years ago

Hi DairyG1 

Please use 

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

 

Change the datatype of the measure as Percentage

DairyG1's avatar
DairyG1
Helper I
3 years ago

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