Forum Discussion

Anonymous

Not applicable

1 year ago

Solved

Make a slicer with AND function

Hello all, For my report I need the user to be able to filter everything that is ONLY requested. So an AND function rather then an OR function. I will provide sample data below: CustomerTbl ...

Need Help

MFelix
1 year ago
Hi Anonymous ,

Here is the file you asked.
ID.pbix26 KB

MFelix

Super User

1 year ago

Hi Anonymous ,

Add a table with the Area has a disconnected table then add the following measure to your model:

Validation = 

			IF(
				CONCATENATEX(
					 VALUES('Action'[Area]),
					'Action'[Area],
					",",
					'Action'[Area]
				) = CONCATENATEX(
					Area,
					Area[Area],
					",",
					Area[Area],
					ASC
				),
				1
			)

Now add this as a filter on your visual an select is not blank the slicer should be based on the new table: