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

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

DairyG1's avatar
DairyG1
Helper I
3 years ago

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