How to Create a Ratio Measure

[saitks99]

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 ?

[amitchandak]

@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]

@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 · Accepted solution]

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