CALCULATE with filter from unrelated column

[SwedeJones]

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

[v-danhe-msft]

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

[v-danhe-msft · Accepted 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

[Greg_Deckler]

Try:

CALCULATE( [Sales] , Table2[City] = MAX( Table1[City] ))

[SwedeJones]

Thank you, didn't work unfortnatly