Forum Discussion

Sax's avatar
Sax
Helper I
3 years ago

Measure behaving differently depending on visual

Hi community,   I'm doing some testing on a simple model: 1 fact table (Sales) connected to a dimension table (Products) and a calendar I have 2 visuals: 1 card and 1 column chart 2 filters...
Need Help
Sax's avatar
Sax
Helper I
3 years ago

Hi, thanks. I know that filtering would work but it's something that I wanted to avoid. 
But conceptually, I still don't understand, why is the treemap working for the card and not for column chart?

Thanks

 

 

johnt75's avatar
johnt75
Super User
3 years ago

In the card the value from the treemap is being as a filter, so SELECTEDVALUE will return a single value. Because the column chart is not being filtered then SELECTEDVALUE will return blank, as multiple values are visible, so your measure will return the value for all products.

  • Sax's avatar
    Sax
    Helper I
    3 years ago

    Thanks...what you just said is still sinking in due to my limited knowledge of functions. 
    I guess another more creative way is to deselect the column chart's title and overlay the card's title instead...