SetAnalysis to count records based on comparison of 2 separate expressions

[lightsection]

I want to count no of records (distinct dates) where Exp1 is greater than Exp2 and present that output in a TEXT BOX.

I am able to achieve this in a straight table, by using IF Conditions, and Counting the Flag in the TOTAL row. But what i actually want is, to present this in a text box (Like a KPI).

Count: If($(Exp1) - $(Exp2) > 0, 1, 0)

[Vegar · Accepted solution]

Maybe like this

Count({<Date={"=$(Exp1) >$(Exp2)"} >} distinct Date)