Forum Discussion
Filterpane: show only related values
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.
2 Replies
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.
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
