Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

How to calculate ratio

Hi Guys, may i know how to calculate ratio based on the situation below ?

The picture below show 10 row, 8 is yes, 2 is no. how can i create measure to calculate ratio of line item that it yes. 

expected result is , 8/10 = 0.8

 

Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    4 years ago

    Anonymous Try:

    Measure = DIVIDE(COUNTROWS(FILTER('Table',[Context]="Yes")), COUNTROWS('Table'),0)

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    4 years ago

    Anonymous Try:

    Measure = DIVIDE(COUNTROWS(FILTER('Table',[Context]="Yes")), COUNTROWS('Table'),0)
  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Anonymous,

    Did the above suggestions help with your scenario? if that is the case, you can consider Kudo or Accept the helpful suggestions to help others who faced similar requirements.

    If these also don't help, please share more detailed information to help us clarify your scenario to test.

    How to Get Your Question Answered Quickly 

    Regards,

    Xiaoxin Sheng