Forum Discussion
Keep A Line in Table or Matrix, but Zero Out the Value when Using Slicer
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?
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.
1 Reply
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.