COUNT Difference between two measures

[Anonymous]

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:

Thanks!

[Ashish_Mathur · Accepted solution]

Hi,

Try this measure

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

Hope this helps.

[VahidDM]

HI @Anonymous 

Try this:

Measure =
VAR _A =
    ADDCOLUMNS (
        SUMMARIZE ( Precios, Precios[Dia], "Auc", [AUCTION], "Pur", [PURCHASE] ),
        "AA", IF ( [Auc] > [Pur], 1, 0 )
    )
RETURN
    SUMX ( _A, [AA] )

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

Appreciate your Kudos!! 

LinkedIn | Twitter | Blog | YouTube