Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

dax

I want to show distinct count of customers_codes but only for those values whose retailing is >0.i want to display this 24225 in a card and not that 24585. both are same distinct count but the ...
Need Help
  • MFelix's avatar
    MFelix
    2 years ago

    Hi Anonymous ,

     

    Try the following:

    Distinct Cout = 
COUNTROWS(
FILTER(
 ADDCOLUMNS(
          ALLSELECTED(Table[Customer_Code]),
          "Retailing", SUM(Table[Retailing])
            ), 
   [Retailing] > 0
       )
)
MFelix's avatar
MFelix
Super User
2 years ago

Hi Anonymous ,

 

Try the following:

Distinct Cout = 
COUNTROWS(
FILTER(
 ADDCOLUMNS(
          ALLSELECTED(Table[Customer_Code]),
          "Retailing", SUM(Table[Retailing])
            ), 
   [Retailing] > 0
       )
)