Forum Discussion
Anonymous
5 years agoNot applicable
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...
- 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")
amitchandak
5 years agoSuper User
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")