Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Dynamic filter values

Hello everyone,   I have an issue to correctly count the distinct products within dynamic filter options. This is my simple data model which consists of only one table. In the first column ...
Need Help
Show and Tell
Tips and Tricks
  • amitchandak's avatar
    amitchandak
    6 years ago

    Anonymous , Assume first date filter is working

     

    M2 =
    var _date = FIRSTDATE(Table[Creation Date])
    var _value = CALCULATE(DISTINCTCOUNT(Table[Product Number]),filter( Table[Creation Date]=_date && ((Table[Country] = "Denmark" && Table[Sales Channel] = "DK Trade") || (Table[Country] = "France" && Table[Sales Channel] = "FR Retail"))
    ))
    RETURN IF(ISBLANK(_value),0,_value)

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

Anonymous , Assume first date filter is working

 

M2 =
var _date = FIRSTDATE(Table[Creation Date])
var _value = CALCULATE(DISTINCTCOUNT(Table[Product Number]),filter( Table[Creation Date]=_date && ((Table[Country] = "Denmark" && Table[Sales Channel] = "DK Trade") || (Table[Country] = "France" && Table[Sales Channel] = "FR Retail"))
))
RETURN IF(ISBLANK(_value),0,_value)

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Oh it seems to work like that! Thank you so much.