Forum Discussion

malguera's avatar
malguera
Frequent Visitor
8 years ago
Solved

Need help with measures combining two tables

Hello Team,   Need some help, I've been trying to sort this out using different combinations of DAX Formulas and I'm still missing a couple of what should be simple measures but for some reason it ...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    malguera

     

    May be you can add another FILTER expression inside CALCULATE

     

    Accounts with Product A only =
CALCULATE (
    DISTINCTCOUNT ( Table1[Account] ),
    FILTER (
        ALLSELECTED ( Table1[Account] ),
        CALCULATE ( DISTINCTCOUNT ( Table1[Product] ) = 1 )
    ),
    Table1[Product] = "A"
)
Zubair_Muhammad's avatar
Zubair_Muhammad
Icon for Community Champion rankCommunity Champion
8 years ago

malguera

 

May be you can add another FILTER expression inside CALCULATE

 

Accounts with Product A only =
CALCULATE (
    DISTINCTCOUNT ( Table1[Account] ),
    FILTER (
        ALLSELECTED ( Table1[Account] ),
        CALCULATE ( DISTINCTCOUNT ( Table1[Product] ) = 1 )
    ),
    Table1[Product] = "A"
)
malguera's avatar
malguera
Frequent Visitor
8 years ago

Thanks Zubair! Seems is working fine, I'll finalize the Dashboard to see how the measure interacts with the rest of calculations.
Very much appreciated!