Forum Discussion

OrenAiz's avatar
OrenAiz
New Member
3 years ago

Card with dynamic column subtotal

Hi,

 

I am trying to present in a card the column subtotal. the column subtotals are part of a dynamic matrix with 4 slicers.

As you can see below, the results in the card are not changed even if the column subtotal changed as a result of using a slicer.

 

 

 

 

 

Need Help

3 Replies

  • v-yadongf-msft's avatar
    v-yadongf-msft
    Community Support
    3 years ago

    Hi OrenAiz ,

     

    Here's a simple sample for your reference.

     

    This is my test table:

     

    Create a measure:

    Measure = CALCULATE(SUM('Table'[Value]),ALL('Table'))

     

    Create visuals:

     

    The results in the card are not changed even if the column subtotal changed as a result of using a slicer.

     

    Best regards,

    Yadong Fang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.