Graph problem with measure.

[Wresen]

Hi and thanks for reading this.

I have a line and cluster column chart and i dont want the columns to be shown for "Bridge Who" when all values are show (se picture A). 

I want it to look like picture B

When i click one one at "Bridge Who" i want it to look like Picture C ( that is working)

So basicly i dont want the values to be shown for "Bridge Who" when we show total , only when one is choosen

I hope i have manage to expalin myself.

The file i work with can be found:
https://drive.google.com/open?id=1xWcUAmV97cMla-BaP6ovRpTJgGi4KWn_

/Thanks

Picures A (How it looks now)

Picure B (This is how i want to look when all is shown)

Picture C 

[amitchandak · Accepted solution]

Not sure I got is completely but isfiltered or isinscope should help

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

Measure = if (isfiltered(table[Bridge Who]), [count of Bridge Who],blank())

[Wresen]

Thanks so much both.

I tried out amitchandak's measure and it worked perfectly 🙂

I will also read up on "HASONEVALUE" so i know about that also 

Thank you both , amitchandak and Greg_Deckler. 

[Greg_Deckler]

@Wresen so I believe the way to fix your issue is to use HASONEVALUE as a check on Bridge Who and then if that is FALSE return BLANK in whatever you are using for your columns. If you are not using a measure, just create one with that check and if it is TRUE, do whatever aggregation you are using on the column used for the value in your columns (in your visual).