Forum Discussion
Show multiple values in table/matrix
1. once you select a value for example 2 in the filter panel, the table visual automatic shows the Name that corresponding to ID 2. It is impossible to show all names.
2. when no ID is selected in the panel, the table visual shows all name in table. It is not possible to achieve your demand of remove "no name" from the list.
Or I misunderstood your question, maybe provide an image view of your expected result.
Paul Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quicly.
Thanks for your anwser, and yes I think I need to elloborate more.
In the table/matrix, when NO ID is selected. It must show all but not 'no name'.
Can maybe do this with
measure= CALCULATE(MAX('Table'[Names]),FILTER('Table','Table'[Names]<>"No Name"))
But when an ID is selected (in filter pane), it must show ALL, so also 'no name' values.
Tried combining the measurement with selected / hasonevalue etc, but no succes so far.
Unfortunately, after a plenty of research and tests it is still impossible to do that.
BTW, I don't see the logic of your use of filter to see all values, because filter is used to see the specific values.
My suggestion would be make your model like the follow:
1. when NO ID is selected. It show all include "no name"
2. create a flag for Name column, using "Name" and "No Name", when "Name" is selected show all names except "no name".
Best, regards
Paul Zheng