Basic question - DirectQuery cards to add up to another card

[Kosenurm]

Hi there,

I have a dashboard in PBI Desktop which uses Direct Query to get data from Dataverse. This is great to present cards using Count to display summarised info. 

What I want is, though, a new data card which takes the Counts of the other datacards and adds them together.

So, to explain, I have 1 data card which shows the amount of cars sold in Pakistan, and another showing the amount of cars sold in France. I'd like a datacard to present all cars sold (so Pakistan + France) as a Count, without importing data to PowerBI. 

Any ideas?

Thanks

K

[v-jayw-msft · Accepted solution]

Hi @Kosenurm ,

Are those values in card visual all measures? Try creating new measure like:

measure3 = measure1+measrure2

Best Regards,

Jay

[amitchandak]

@Kosenurm , You have create a new measure and use that.

Or have two values filtered on this card, if you are using, one value on each visual

[Kosenurm]

Thanks for your reply. I have tried new measure, but this puts the Measure inside one of my data tables and then I can't use it in SUM command to add up the values. I can't move the Measure outside of one of the data tables, and can't get it to be able to SUM across multible tables.

Any ideas?

Thanks

K