Filterpane: show only related values

[ChrisByrdal]

Is it possible to only get related values in a filter on the filter pane - when another dimension has been limited?
I har a sales fact table with two dimensions - country and product - when I limit the country I would like the product to be limited to possible values for that specific country.

I would like to use standard filter panes, not slicers.
My data comes from a cube.
I have a rather complex model (not the one described above - that was just for clarification) - therefor I prefer not to use both direction in the relationships to my fact table.

[ChrisByrdal]

Hi @Anonymous 

It's not in the measure I have a problem 🙂

It's in the filter pane - I have a lot of data and would like one dimension to only show valid values when there has been a selection on the other dimension.
For now I have solved my issue by changing the connection from single to both - but I'm not sure it's a good idea considering performance.

Best regards Chris

[Anonymous]

Hi @ChrisByrdal 

You can consider to use all() function to remove all filters in a measure

e.g 

Measure =
CALCULATE ( SUM ( Table[Value] ), FILTER ( ALL ( Table ), [Country] = "xxx" ) )

You can refer to the following link about the function.

ALL function (DAX) - DAX | Microsoft Learn

Best Regards!

Yolo Zhu

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