slicer fact table, missing items matrix

[jhavdn]

So ive got the following problem. I have a column in my fact table that i use as a slicer. I know its better to create a new table but due to circumstances thats not possible, so i hope some one can point out a work around without creating new columns or tables. 

situation the top left matrix i want to filter and the price2_tag is from the fact table:

the top left matrix is the problem, with my dax query i remove the filter from column price2_tag

when i activate the filter i ignore the filter with the dax query for sum price (ALL). On total its correct but i want item "18" to appear in the list, is this possible? (same for item "15") 

When i filter with the slicer I lose the item "18" but i want it visible (the total is correct because of the ALL in the dax.

[Anonymous · Accepted solution]

Hi @jhavdn ,

Unfortunately, it is by design and you will need to create an independent slicer table.

Best Regards,

Jay