Forum Discussion
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 ...
Hi Anonymous ,
Here is the file you asked.
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: