Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I am trying to create a measure which sums values of different columns based on filter. Say I have 2 tables:
Currency table
CurrencyCode |
USD |
EUR |
Sales table
RevenueUSD | RevenueEUR |
10 | 9 |
50 | 47 |
I need to create a measure that would SUM the revenue from appropriate column when Currency table is applied as filter (i.e. when it's set as USD - measure sums RevenueUSD column, when it's set as EUR - measure sums RevenueEUR column). Is there any way to achieve this?
Thanks for help
Solved! Go to Solution.
Hello @nesisekasi,
Please find the below solution that works. Also, please note this will work only for Single Selection in the Filter:
Here is the formula for the measure:
Please mark this as solution if it helps.
Thank you,
Pradeep Chowdavarapu
"Even if no one believes you can,
YOU GOT TO BELIEVE YOU CAN."
Hello @nesisekasi,
Please find the below solution that works. Also, please note this will work only for Single Selection in the Filter:
Here is the formula for the measure:
Please mark this as solution if it helps.
Thank you,
Pradeep Chowdavarapu
"Even if no one believes you can,
YOU GOT TO BELIEVE YOU CAN."
User | Count |
---|---|
77 | |
75 | |
67 | |
65 | |
47 |
User | Count |
---|---|
108 | |
105 | |
93 | |
83 | |
65 |