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,...
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

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