Count number of occurences where one measure is larger than another

[phiilip]

Hello!

I have two measures, let's call them A and B for simplicity's sake. Both of these measure are over time, by week in this case. Now I want to display a KPI where I count the amount of times where A > B. How do I implement this logic in the frontend?

Thanks in advance!

[Or · Accepted solution]

Without knowing what the measures are, a general answer: Use Aggr().

Sum(Aggr(If(Sum(A) > Sum(B),1),YourDim1,YourDim2))