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.

VahidDM's avatar
VahidDM
Super User
3 years ago

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