Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

How to write Dax condition when selected slicer (multiple selection) is equal values in column

Hi experts, I need advise and help in Dax writing.   Here are the scenario, I have a Slicer with settings multiple selection and value {"A", "B", "C", "D" & "E"}. Next I have a table with colu...
  • amitchandak's avatar
    5 years ago

    Anonymous , Try mesure like

     


    measure =
    var _cnt = countx(allselected(Slicer), slicer[value])
    return
    if( calculate(distinctCOUNT(Table[column]), filter(Table, Table[column] in values(slicer[value]))) >=__cnt, "Yes", "No")