Forum Discussion

PowerKoen's avatar
PowerKoen
Frequent Visitor
6 years ago

Show multiple values in table/matrix

Hi there,   Got an table sales with the following columns:   Sales[ID] Sales[Names]   In an matrix/table visual i want to show the following:   ID Names 1 No name 2 April 3 B...
Need Help
PowerKoen's avatar
PowerKoen
Frequent Visitor
6 years ago

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. 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

PowerKoen 

 

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