cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SwedeJones Frequent Visitor
Frequent Visitor

CALCULATE with filter from unrelated column

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

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: CALCULATE with filter from unrelated column

Hi @SwedeJones,

Based on my test, you could refer to below formula:

Measure = CALCULATE( MAX([Sales]) , FILTER('Table2',Table2[City] = SELECTEDVALUE( Table1[City])))

Result:

1.PNG

 

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 REPLIES 4
Super User
Super User

Re: CALCULATE with filter from unrelated column

Try:

 

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

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


SwedeJones Frequent Visitor
Frequent Visitor

Re: CALCULATE with filter from unrelated column

Thank you, didn't work unfortnatly Smiley Indifferent

Community Support Team
Community Support Team

Re: CALCULATE with filter from unrelated column

Hi @SwedeJones,

Based on my test, you could refer to below formula:

Measure = CALCULATE( MAX([Sales]) , FILTER('Table2',Table2[City] = SELECTEDVALUE( Table1[City])))

Result:

1.PNG

 

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community Support Team
Community Support Team

Re: CALCULATE with filter from unrelated column

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

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.