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
johnt75's avatar
johnt75
Super User
3 years ago

The treemap isn't filtering the column chart, its cross highlighting it, which means that no filters are passed into your measure. I don't think that there is a way to detect whether or not cross highlighting is in effect.

You could use Edit Interactions to make the treemap filter the column chart instead of cross highlighting, that should work.

  • 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...