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 further set the Calculation Type to % of GrandTotal. Any idea why this does not work? TIA.

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 ) )
)

2 Replies

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