Forum Discussion

preve05's avatar
preve05
Frequent Visitor
8 years ago
Solved

Filter for Card Visual does not work % of GT

Hi, I have a TreeMap showing %of GrandTotal and a Card visual that I am trying to update when a branch is clicked. It updates when I set the Field for Card to Sum of Quantity but does not when I furt...
Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    8 years ago

    preve05,

     

    You may add a measure instead.

    Measure =
DIVIDE (
    SUM ( Table1[Column2] ),
    CALCULATE ( SUM ( Table1[Column2] ), ALL ( Table1 ) )
)
v-chuncz-msft's avatar
v-chuncz-msft
Icon for Community Support rankCommunity Support
8 years ago

preve05,

 

You may add a measure instead.

Measure =
DIVIDE (
    SUM ( Table1[Column2] ),
    CALCULATE ( SUM ( Table1[Column2] ), ALL ( Table1 ) )
)
preve05's avatar
preve05
Frequent Visitor
8 years ago

Created a new measure as suggested above for the Card visual and it worked. Thanks!