topic Re: Changing slicer condition to AND in DAX Commands and Tips

Changing slicer condition to AND

WOLFIE — Mon, 21 Feb 2022 10:27:13 GMT

Hi all,

I am trying to work this out for ages. I found many different solutions online, but nothing worked. It's a simple one table one slicer solution. I need to filter the ID by the selected rules in the slicer. PBI default is OR condition, but I need to change it to AND.

data:
IDRule

1	a
2	a
2	b
3	c
3	a
3	d
4	b
4	a
5	b
6	d
6	e
7	d
7	e
7	a
7	f
7	g
8	d
8	a
9	e
10	a
10	d

Thanks 🙂

Re: Changing slicer condition to AND

amitchandak — Mon, 21 Feb 2022 11:00:35 GMT

WOLFIE , Try Measure

measure =
var _cnt = calculate(DistinctCount('Table'[Rule]) ,allselected('Table'))
return
countx(filter(summarize('Table', 'Table'[ID], "_1", DistinctCount('Table'[Rule])),[_1]=_cnt),[ID])

measure =
var _cnt = calculate(DistinctCount('Table'[Rule]) ,allselected('Table'))
return
calculate(countx(filter(summarize('Table', 'Table'[ID], "_1", DistinctCount('Table'[Rule])),[_1]=_cnt),[ID]), filter(allselected(Table), Table[ID] =max(Table[ID])))

Re: Changing slicer condition to AND

WOLFIE — Mon, 21 Feb 2022 11:12:29 GMT

The second one works! 🙂 Thanks so much!!!

Re: Changing slicer condition to AND

WOLFIE — Mon, 21 Feb 2022 13:59:04 GMT

amitchandak Quick additional question 🙂 I need the table to keep all values when nothing is selected in the slicer. I tried this, but it doesn't work:

measure =

VAR _cnt = CALCULATE(DISTINCTCOUNT('Customer'[Rule]) ,ALLSELECTED('Customer'))

RETURN

IF(ISFILTERED(Customer),

CALCULATE(

COUNTX(

FILTER(

SUMMARIZE('Customer', 'Customer'[ID], "_1",

DISTINCTCOUNT('Customer'[Rule])),[_1]=_cnt),[ID]),

FILTER(ALLSELECTED(Customer),'Customer'[ID] = MAX('Customer'[ID])

)

),1)

Re: Changing slicer condition to AND

WOLFIE — Mon, 21 Feb 2022 14:28:52 GMT

SOLVED 🙂