topic Re: How to obtain the values that are not included in a data segmentation? in DAX Commands and Tips

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

Anonymous — Thu, 24 Feb 2022 20:31:22 GMT

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!

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

Greg_Deckler — Thu, 24 Feb 2022 22:53:09 GMT

Anonymous Sounds like an Inverse Selector or Inverse Aggregator:

Inverse Selector - Microsoft Power BI Community

Inverse Aggregator - Microsoft Power BI Community

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

Jihwan_Kim — Fri, 25 Feb 2022 03:36:05 GMT

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] )
)
)