Exclude selected slicer - different parameters

Hi Anonymous ,

There are some ways maybe help you.

One way to exclude data based on a slicer selection is to use the EXCEPT function in DAX to return the difference between two tables. For example, you can create a measure like this:

Selection Exclude Events = CALCULATE ( SUM ( Events[Value] ), EXCEPT ( ALL ( Events[Month] ), VALUES ( Events[Month] ) ) )

This measure will sum up the values of the events that are not in the selected month.

Another way to exclude data based on a slicer selection is to use the ISFILTERED and NOT functions in DAX to check if a column is filtered and return the opposite value. For example, you can create a measure like this:

Selection Exclude Events = IF ( ISFILTERED ( Events[Month] ), NOT ( Events[Month] IN VALUES ( Events[Month] ) ), 1 )

This measure will return 1 for the events that are not in the selected month, and 0 otherwise.

A third way to exclude data based on a slicer selection is to use the USERELATIONSHIP and ALLSELECTED functions in DAX to activate an inactive relationship and filter by the selected values. For example, you can create a measure like this:

Selection Exclude Events = CALCULATE ( SUM ( Events[Value] ), USERELATIONSHIP ( Events[Month], ExcludeEvents[Month] ), ALLSELECTED ( ExcludeEvents ) )

This measure will sum up the values of the events that are related to the selected month in the ExcludeEvents table, which is a disconnected table with an inactive relationship with the Events table.

How to Get Your Question Answered Quickly 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.