Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more
Hi, I am trying to show total engine miles traveled by an engine over a specific date range and the total miles.
Something like this, Total miles based on dates selected / (Not divide) Total Overall miles. In the same card
I am able to get total miles based on dates with a simple DAX query but now I also want to show the overall miles with it.
I am not very sure how to approach this problem can anyone help.
Thanks
Solved! Go to Solution.
Make a similar measure for overall total miles, using some sort of ALL/ALLEXCEPT filter to ignore your dates, then for your card concatenate the two together with something like:
cardmeasure = concatenate([existingmeasure],concatenate(" / ",[newmeasure]))
Make a similar measure for overall total miles, using some sort of ALL/ALLEXCEPT filter to ignore your dates, then for your card concatenate the two together with something like:
cardmeasure = concatenate([existingmeasure],concatenate(" / ",[newmeasure]))
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.