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!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! 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]))
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 37 | |
| 37 | |
| 33 | |
| 32 | |
| 29 |
| User | Count |
|---|---|
| 132 | |
| 88 | |
| 82 | |
| 68 | |
| 64 |