Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

COUNT Difference between two measures

I have two measures: AUCTION and PURCHASE and I need to count how many times AUCTION is larger than PURCHASE.   Both AUCTION and PURCHASE are coming from a measure calculated like this: ...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    3 years ago

    Hi,

    Try this measure

    =countrows(filter(values(calendar[Dia]),[Auction]>[Purchase]))

    Hope this helps.

Ashish_Mathur's avatar
Ashish_Mathur
Super User
3 years ago

Hi,

Try this measure

=countrows(filter(values(calendar[Dia]),[Auction]>[Purchase]))

Hope this helps.