Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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 |
---|---|
98 | |
90 | |
84 | |
71 | |
67 |
User | Count |
---|---|
114 | |
103 | |
100 | |
72 | |
64 |