Forum Discussion

kotarosai's avatar
kotarosai
Icon for Helper II rankHelper II
5 years ago
Solved

DISTINCTCOUNT with multiple filter criteria

Hello, I am having an issue with a measure / formula. One works as intended when using an OR logic but does not work as intended with an AND. Both formulas are below and the measure is shown in the m...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    kotarosai , Try like and check

     

    Retained Accounts Past QTR = Countrows(
    filter(values('Sales Result'[Account]),'Sales Result',[Accounts Ordered Past QTR] > 0 && [Accounts Ordered 2 QTRs Ago] > 0))

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

kotarosai , Try like and check

 

Retained Accounts Past QTR = Countrows(
filter(values('Sales Result'[Account]),'Sales Result',[Accounts Ordered Past QTR] > 0 && [Accounts Ordered 2 QTRs Ago] > 0))

kotarosai's avatar
kotarosai
Icon for Helper II rankHelper II
5 years ago

That worked great, thanks so much amitchandak!