How to obtain the values that are not included in a data segmentation?

[Anonymous]

Hi,

How to obtain the values that are not included in a data segmentation?

I have this slicer and I want to know which values were not selected, in this case the value that was not selected was 06- Export Affiliate,

is it possible to obtain this value in Power BI? What happens is that I have to do a subtraction when everything except the value "06- Export Affiliate" is selected but if all the filter values are selected a division is made, I have tried to use the ISFILTERED AND ALLSELECTED functions but it has not worked, does anyone have an idea of another way I can do it , Thank you!

[Greg_Deckler · Accepted solution]

@Anonymous Sounds like an Inverse Selector or Inverse Aggregator:

Inverse Selector - Microsoft Power BI Community

Inverse Aggregator - Microsoft Power BI Community

[Jihwan_Kim · Accepted solution]

Hi,

I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file.

QTY total: =

SUM( Data[QTY] )

QTY total slicer not select: =
CALCULATE (
[QTY total:],
FILTER (
category,
NOT ( Category[Category] ) IN VALUES ( 'Category slicer'[Category] )
)
)

[Greg_Deckler · Accepted solution]

@Anonymous Sounds like an Inverse Selector or Inverse Aggregator:

Inverse Selector - Microsoft Power BI Community

Inverse Aggregator - Microsoft Power BI Community