How to make a card that is the sum of multiple cards

[Anonymous]

Hi, 

I was hoping to make a visual that could show the summary of 5 cards ie. card 1 = 10 , card 2 = 79 ect ; summary card would be 89. 

Is this possible? below is my cards I was hoping to summaries on one card so that i could know the total of all these values. 

Kind regards, 

Jemma 

[Anonymous]

Hi @Anonymous 

If your current cards are built by dragging a column into it and making it display Count of that column values, you can create a new measure to calculate the total count of all. For example, 

Total = COUNT('Table'[column A]) + COUNT('Table'[column B]) +... + COUNT('Table'[column E])

If you are not using Count, you just need to modify it accordingly. 

Regards,

Jing

[datawailor · Accepted solution]

You could use the new card visual to achieve the look. As to the values, if you use measures that equate to the total then yes, this is doable. This implies if measure 1 = 5, measure 2 = 7 then measure 3 = measure 1 + measure 2. Arranged in this order in the new card visual should give you what you need.