Forum Discussion

js124's avatar
js124
Frequent Visitor
6 years ago

Changing Column Total in Table to Card Visual

I'm trying to change the "Potential Uplift" total in the table below to a value in a separate card visual:

I tried to achieve this by duplicating the matrix table, removing all value columns besides "Pontential Uplift", and then selecting the card visual, but the value shown in the card is incorrect:

 

I think it has something to do with the "Parent Client" rows being removed when switching the card visual, but I can't seem to get the card to match the 5.23M number, even though all the filters from the table were copied to the card visual. 

 

 

1 Reply

  • Nathaniel_C's avatar
    Nathaniel_C
    Icon for Community Champion rankCommunity Champion
    6 years ago

    Hi js124 ,

    Try this measure: Sum(YourTaBleName[Potential Uplift])


    Let me know if you have any questions.

    If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
    Nathaniel