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:

Thanks!

 

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.

2 Replies

  • 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 



  • 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.