Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
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]))