dynamic title - A table of multiple values was supplied where a single value was expected.

[Sam09]

I am showing a dynamic title based on the slicer selection which is failing in some scenarios and showing the below error:

A table of multiple values was supplied where a single value was expected.

 Scenario i'm showing the dynamic title is as below:

1) I have a Table1 visualization which shows the product and A1Count,A2Count which are measures created to show the sum.

2)Created another table2 visualization when user click on Table1 any row, it shows that row information in the second table. visualization.

3)Created a slicer to select the Levels(A1,A2).

4)Created a Card visualization which shows the dynamic title as below:

dynamicTitle = "" & CONCATENATE(VALUES('ProdData'[Level])," product is ") & CONCATENATE(VALUES('ProdData'[Pname]),"")

Two issues i'm facing with the above scenario:

1)When i go to other tab and come back to this tab, or close the .pbix file and again open , on the title card it is showing "Can't display the visual" and the error it is showing is as below:

Calculation error in measure 'ProdData'[dynamicTitle]: A table of multiple values was supplied where a single value was expected.

2)When i click on a row and if i click on A1/A2 on a slicer whose value is 0(zero), it is showing the title as "product is" , it is not showing the label name or the product selected.

Need help.

[v-yulgu-msft]

Hi @Sam09,

Please try this:

dynamicTitle =
"" & CONCATENATEX ( VALUES ( 'ProdData'[Level] ), 'ProdData'[Level], " " )
    & "Product is"
    & CONCATENATEX ( VALUES ( 'ProdData'[Pname] ), 'ProdData'[Pname], "" )

Best regards,

Yuliana Gu

[Sam09]

@v-yulgu-msft - Thanks for the inputs. It is failing in two scenarios, need help.

1)When there is no value for the A2Count i'm showing as 0(zero), in the title it is not appending the Level or the Pname. It is showing as shown in below image when clicked on row with Pname 'PC' whose A2Count is 0. Expected title is "A2 Product is PC".

2)When i double click on the row or click for the second time in the Table1 visualization, in Table2 it is showing all the rows information with A2 level instead of only showing that row information(I think this is how clicks on table visualization works, but can we control and show only the row information in Table2 even when user do multiple clicks on the same row?) and it is showing all Pnames in the dynamicTitle as shown in below picture. The same thind is happening when i change from this tab to other and comeback to this tab, it is showing all product names in the title...