Forum Discussion

DHB's avatar
DHB
Helper V
7 years ago
Solved

Card Percentages not Changing

I'm using 2 cards in my dashboard.  One shows count a of records and this number changes when I use filters.  The other card shows the value as a percentage of the records but does not change when I use filters and stays at 100%.  I can't find any way to make this second card change according to filters. 

 

Any tips?

 

Thank you.

 

DHB

 

 

Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    7 years ago

    DHB,

     

    You may try the measure below.

    Measure =
DIVIDE (
    COUNT ( Table1[Column1] ),
    CALCULATE ( COUNT ( Table1[Column1] ), ALL ( Table1 ) )
)

2 Replies

  • v-chuncz-msft's avatar
    v-chuncz-msft
    Community Support
    7 years ago

    DHB,

     

    You may try the measure below.

    Measure =
DIVIDE (
    COUNT ( Table1[Column1] ),
    CALCULATE ( COUNT ( Table1[Column1] ), ALL ( Table1 ) )
)
    • DHB's avatar
      DHB
      Helper V
      7 years ago

      That's great, works perfectly. Thank you.