Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have 3 seperate cards, reporting the following:
The changes and the backlog come from 2 different tables and are filtered differently. Is there a method in which I can sum the 3 cards together, giving me a total?
Solved! Go to Solution.
If the cards are being fed by measures, you could just make a new fourth measure that's something like:
OverallTotal = calculate([yettobill])+calculate([backlogchanges])+calculate([installedvalue])
As you're using calculate rather than just adding the three together, you can then put the relevant filter context into each bit of the formula to get your desired results, for example if the last one was just calculated over where some field foo has the value bar, you'd have calculate([installedvalue],yourtable[foo]="bar")
If the cards are being fed by measures, you could just make a new fourth measure that's something like:
OverallTotal = calculate([yettobill])+calculate([backlogchanges])+calculate([installedvalue])
As you're using calculate rather than just adding the three together, you can then put the relevant filter context into each bit of the formula to get your desired results, for example if the last one was just calculated over where some field foo has the value bar, you'd have calculate([installedvalue],yourtable[foo]="bar")
That is perfect thankyou.
To be honest, I never thought about using measures because of the filters applied, however the filters are just as applicable to the meaure, as they are the intial results....
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
97 | |
78 | |
64 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |