Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Kosenurm
Regular Visitor

Basic question - DirectQuery cards to add up to another card

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

1 ACCEPTED SOLUTION
v-jayw-msft
Community Support
Community Support

Hi @Kosenurm ,

 

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

measure3 = measure1+measrure2

 

Best Regards,

Jay

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.

View solution in original post

3 REPLIES 3
v-jayw-msft
Community Support
Community Support

Hi @Kosenurm ,

 

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

measure3 = measure1+measrure2

 

Best Regards,

Jay

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.
amitchandak
Super User
Super User

@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

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

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.