Forum Discussion
Slicer with And functionality
Hello all !
I have two slicers 1. Technologies 2. Languages
when ever I need to multiselect the languages i need the list of employees who ever involves in that multi select slicer.
ref : Slicer with AND functionality
Hi SureshNaik123 ,
Based on your description, I have created a simple sample:
Please try to add this measure to the visual level filter:
Slicer AND logic = VAR _a = ALLSELECTED ( 'Employee data_new'[Languages] ) VAR _b = COUNTROWS ( FILTER ( ALL ( 'Employee data_new' ), [ID] = MAX ( 'Employee data_new'[ID] ) && [Technologies] = MAX ( 'Employee data_new'[Technologies] ) && [Languages] IN _a ) ) RETURN IF ( _b = COUNTROWS ( _a ), 1, 0 )Final output:
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
I have written this dax please check
Slicer AND logic =var sel_T = VALUES('Employee data_new'[Languages])var distcnt = COUNTROWS(DISTINCT(SELECTCOLUMNS(FILTER('Employee data_new',SUMX('Employee data_new',DISTINCTCOUNT('Employee data_new'[Languages]) in sel_T)))))var cntL = COUNTROWS(sel_T)returnIF(distcnt >= cntL,distcnt)Hi SureshNaik123 ,
Based on your description, I have created a simple sample:
Please try to add this measure to the visual level filter:
Slicer AND logic = VAR _a = ALLSELECTED ( 'Employee data_new'[Languages] ) VAR _b = COUNTROWS ( FILTER ( ALL ( 'Employee data_new' ), [ID] = MAX ( 'Employee data_new'[ID] ) && [Technologies] = MAX ( 'Employee data_new'[Technologies] ) && [Languages] IN _a ) ) RETURN IF ( _b = COUNTROWS ( _a ), 1, 0 )Final output:
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
