only showing data in a table when a customer is selected (updated)

[Anonymous]

Hello all,

I have a table that looks like this:

I am trying to create a DAX measure that I can add to a table visual that will only show data when a customer is selected, for example the table would show this:

Until you selected a customer, then the table would look like this:

the logic would be - if company has one value then return all companyID, else return "No Customer Selection"  same logic for the other columns with reguards to the column names

How could I accomplish this? here is the sample file

[v-easonf-msft · Accepted solution]

Hi , @Anonymous 

Here is  a workaround ,maybe you can take a try.  ( pbix attached)

step1. create a seperate table as slicer

Table 2 = DISTINCT(Attachements[CompanyName])

step 2. create a visual control measure as below:

Measure = IF(ISBLANK(SELECTEDVALUE('Table 2'[CompanyName])),0,1)

apply it  the filter pane as below:

The result will show as below:

  

The only drawback is that it does not display a record "no customer selected".

I hope that others can propose better solutions, and I will continue my further research.

Best regards,

Eason Fang

[Anonymous]

thank you @v-easonf-msft this worked perfectly. I appreciate the help