Forum Discussion
Dynamically show data in table when another visualisation is selected
I have a pie chart showing total income based on three different platforms. You can then break the platform down to database, so underneath the pie I have a table showing database and total income....
you can use the hasonefilter function and then rplace with blank if not true
in the code below replace sum('Table'[amt]) with the measure you are showing in your table
measure = if(HASONEFILTER('Table'[platform]),sum('Table'[amt]),BLANK())
AnthonyTilley
Solution Sage
Solution Sageyou can use the hasonefilter function and then rplace with blank if not true
in the code below replace sum('Table'[amt]) with the measure you are showing in your table
measure = if(HASONEFILTER('Table'[platform]),sum('Table'[amt]),BLANK())
Hurrah, this works AnthonyTilley thanks so much! Sorry for the delay have been off work for a week but this is super :-)