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 this please?

 

Thank you

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

4 Replies

  • Idrissshatila's avatar
    Idrissshatila
    Super User
    3 years ago

    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

  • 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