Forum Discussion

DaxNewbie's avatar
DaxNewbie
Frequent Visitor
8 years ago
Solved

Calculate() filtered by another measure

Hello,   I am trying to filter a calculate() statement with another calculated measure. I have looked at serveral previous questions, but those solutions did not seem to work. Any assistance with m...
Need Help
  • Vvelarde's avatar
    Vvelarde
    8 years ago

    DaxNewbie

     

    Hi, try with this:

     

    Measure = COUNTX(VALUES(Table2[Name]),IF([MoveCalcFilter]=3,1,BLANK()))

     

    Regards

     

    Victor

Vvelarde's avatar
Vvelarde
Icon for Community Champion rankCommunity Champion
8 years ago

DaxNewbie

 

Hi, try with this:

 

Measure = COUNTX(VALUES(Table2[Name]),IF([MoveCalcFilter]=3,1,BLANK()))

 

Regards

 

Victor

DaxNewbie's avatar
DaxNewbie
Frequent Visitor
8 years ago

Vvelarde

 

Thank you Victor! You are wonderfully helpful!