Forum Discussion

Standish's avatar
Standish
Frequent Visitor
5 years ago
Solved

DAX Measure Referencing Other Measures

Hello,   I have a requirement to display the below in a card visual. I am looking to display: the sum of Measure 1 where Measure 2 = 0 - Expected result would be 27.  - Current result is 36. (In...
Need Help
  • AlB's avatar
    AlB
    5 years ago

    Hi Standish 

    Measure = 
SUMX(  
    DISTINCT('Tbl_Vendors'[VendorID]) ,
    IF([Measure2]=0,[Measure1], 0)
)

    Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

    Contact me privately for support with any larger-scale BI needs, tutoring, etc.

    Cheers 

     

Standish's avatar
Standish
Frequent Visitor
5 years ago

Hi AlB 

This worked like a charm. Thank you very much.