Forum Discussion

Kosenurm's avatar
Kosenurm
Regular Visitor
4 years ago
Solved

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

Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Kosenurm ,

     

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

    measure3 = measure1+measrure2

     

    Best Regards,

    Jay

3 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    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's avatar
      Kosenurm
      Regular Visitor
      4 years ago

      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

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Kosenurm ,

     

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

    measure3 = measure1+measrure2

     

    Best Regards,

    Jay