Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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
Solved! Go to Solution.
Hi @Kosenurm ,
Are those values in card visual all measures? Try creating new measure like:
measure3 = measure1+measrure2
Best Regards,
Jay
Hi @Kosenurm ,
Are those values in card visual all measures? Try creating new measure like:
measure3 = measure1+measrure2
Best Regards,
Jay
@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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
121 | |
80 | |
47 | |
45 | |
33 |
User | Count |
---|---|
174 | |
90 | |
69 | |
47 | |
46 |