dax

[Anonymous]

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 table one (24225) is calculated after i took sum of retailing in>0 filter plane. but im not able to take that sum of retailing in card visual. 

[MFelix · Accepted solution]

Hi @Anonymous ,

Try the following:

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