Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |