Forum Discussion

Microsoft Employee

5 years ago

Solved

How to Create a Ratio Measure

Forumal for measure :

Ratio = (CALCULATE(SUM(Query1[RenewalCount]),FILTER(Query1, Query1[EligibleTrackingDay]== "1")))

I want Ratio column to show the renewal count as 8360492 in both the rows, why it is only showing up when EligibleTrackingDay == 1 ?

v-easonf-msft
5 years ago
Hi , saitks99

Try to use function"All "as below :

Ratio = (CALCULATE(SUM(Query1[RenewalCount]),FILTER(ALL(Query1),Query1[EligibleTrackingDay] = 10)))

Best Regards,
Community Support Team _ Eason

3 Replies

amitchandak
Super User
5 years ago
saitks99 ,

Your formula should be like
Ratio = (CALCULATE(SUM(Query1[RenewalCount]),FILTER(Query1, Query1[EligibleTrackingDay]= "1")))

But Ratio should be like

Ratio = divide(CALCULATE(SUM(Query1[RenewalCount])),CALCULATE(SUM(Query1[RenewalCount]),all(Query1)))
- saitks99
  Microsoft Employee
  5 years ago
  amitchandak
  I over simplified my question:
  
  Actually, this is what I have, Forumula used for Ratio :
  Ratio = (CALCULATE(SUM(Query1[RenewalCount]),FILTER(Query1,Query1[EligibleTrackingDay] = 10)))
  
  ***I want 8488163 should be repeated in entire table, help me out !
  - v-easonf-msft
    Community Support
    5 years ago
    Hi , saitks99
    
    Try to use function"All "as below :
    
    Ratio = (CALCULATE(SUM(Query1[RenewalCount]),FILTER(ALL(Query1),Query1[EligibleTrackingDay] = 10)))
    
    Best Regards,
    Community Support Team _ Eason

Related content