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 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. 

 

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
       )
)

1 Reply

  • 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
       )
)