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.
Hi,
I have two tables which for several reasons are unrelated but contain same cities. Table1 & Table2.
I wish to calculate [Sales] based on the slicer of one of them but calculate for the other like this:
CALCULATE( [Sales] , Table2[City] = SELECTEDVALUE( [Table1[City] ))
However, I cannot get the above to work. Any suggestions?
I am using a Tabular/live Azure cube.
Thank you,
BR Jonas
Solved! Go to Solution.
Hi @SwedeJones,
Based on my test, you could refer to below formula:
Measure = CALCULATE( MAX([Sales]) , FILTER('Table2',Table2[City] = SELECTEDVALUE( Table1[City])))
Result:
Regards,
Daniel He
Hi @SwedeJones,
Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered to close this topic?
Regards,
Daniel He
Hi @SwedeJones,
Based on my test, you could refer to below formula:
Measure = CALCULATE( MAX([Sales]) , FILTER('Table2',Table2[City] = SELECTEDVALUE( Table1[City])))
Result:
Regards,
Daniel He
Try:
CALCULATE( [Sales] , Table2[City] = MAX( Table1[City] ))
Thank you, didn't work unfortnatly
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 |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |