Forum Discussion
Error SelectedValue
quickbi ok, my next hypothesis is that there are some null or blank values getting in the way. Can you try changing your selectedvalue test to use
CONCATENATEX( VALUES(tablename[Level1]), tablename[Level1], ", " )
You may need to add some filter modifiers to your calculate and/or selectedvalue. You can see the selectedvalue test is blank for the top row for each level 1 account in your visual, and because Margin is collapsed the top row is the only one that exists.
Hi AllisonKennedy
thanks for your answer but is not the problem because all level1 are showing if they are or aren't collapsed.
...and I expanded all Margin level but did not show anyvaluequickbi ok, my next hypothesis is that there are some null or blank values getting in the way. Can you try changing your selectedvalue test to use
CONCATENATEX( VALUES(tablename[Level1]), tablename[Level1], ", " )
