Exclude data

[javedbh]

Hi All,

I have a table with multiple columns e.g. (Device, Program, Lot Number, Finish Date, Yield). Lot is the smallest or base entity. Program and Device are higher in hierarchy.

I have created multiple visuals to display Yield e.g.

one visual to display yield with Lot Number on x-axis.

another visual to display yield with Program on x-axis.

another visual to display yield with Device on x-axis.

another visual to display yield with Finish Date on x-axis.

There are thousands of Lots in the data. I want to give the user ability to exclude specific lots appearing in the charts. These lots should be excluded from visuals. I know we can apply filters either at Visual, Page, or Report level but these filters work like If I select these items, these would be included in the visual(s). Is there any thing that work like this: If I select these items from the list, these would be excluded. Any Filter or custom visual or any other idea?

Thanks in Advance.

[v-yuezhe-msft]

Hi @javedbh,

You can create a Lot table listing all the lots , then create a relationship between Lot table and your current table. After that, create a measure using the following DAX, then create visuals using the measure and other columns of your current table and create a slicer or other filters(Page level filter and so on) using Lot field of Lot table, this way, you will be able to achieve the above requirement.

Measure = CALCULATE(SUM(Yourtable[Yield]),EXCEPT(ALL('Lot table'),'Lot table'))

You  can review the example in the screenshots below.


Thanks,
Lydia Zhang