Keep A Line in Table or Matrix, but Zero Out the Value when Using Slicer

[Anonymous]

Hello,

I have a slicer that's being used to filter out various reasons for my dataset's adjustments. I want to be able to uncheck certain catergories in the slicer without removing the row from my Matrix.

In the screenshot, if I drop the "Pending" checkbox, it will remove the whole row that the arrow points too, because the reason for the first "Adj Impact" relates to "Pending".

I want to be able to retain that row, but have the value for this column go to 0. Any advice on where to begin?

[v-yangliu-msft · Accepted solution]

Hi  @Anonymous  ,

I created the data:

Here are the steps you can follow：

1. Create calculated table.

Table 2 = SUMMARIZE('Table (2)','Table (2)'[flag])

2. The relationship between the two tables.

3. Create measure.

Amount1 =
var _flag=SELECTCOLUMNS('Table 2',"1",[flag])
return
IF(MAX('Table (2)'[flag]) in _flag,SUMX(FILTER(ALL('Table (2)'),[flag]=SELECTEDVALUE('Table 2'[flag])),[amount]),0)

4. Do not select Pending in Filters.

5. Result.

There is no Pending column in the slicer, but it is displayed in the matrix and is 0

Best Regards,

Liu Yang

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