Treemap and Card

[xierwee]

Hi, I have a question regarding Treemap and Card when they are connnected. 

when I click one block in the Treemap, a corresponding value will be displayed in the Card. When nothing in the Treemap is selected, it will show the sum of the values in the Card data. But I'd like to show another value in the Card data when nothing is selected in the Treemap.

Thank you in advance. 

[Sabeeluzzama]

PLease try to use HASONEFILTER or ISFILTERED in the measure you are using in the card.

it should work 🙂

[xierwee]

thank you!

[amitchandak · Accepted solution]

You can use isfiltered or hasonevalue. or isinscope depend on your formula need what you want to display

Please refer.

https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/

Provide more information, to help further.