How to calculate ratio for this scenario

[saitks99]

My Question is :

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 !

[CNENFRNL · Accepted solution]

Hi, @saitks99 , pls try this

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

[saitks99]

This worked, what is the difference with FILTER then ?

[CNENFRNL]

Hi, @saitks99 , in fact, it's EVALUATION CONTEXT which is in play here. I recommend a classic blog by Jeffrey Wang unveiling some essential details in this regard.

[Icey]

Hi @saitks99 ,

You can also try this:

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

It should work the same as what @CNENFRNL mentioned.

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.