Using a column as a conditional in a measure

[Henrique_Quint]

Hey everyone, hope everyone is alright!

Basically I have three tables (A dimension table, and two others), what I need to do is create a conditional so I can sum one of the two tables (lets call them sales 1 and sales 2).

Here's a mockup of what I want to do, but it doesn't work: IF(Dimension[State]=A,SUM(Sales 1[Sales]),SUM(Sales 2[Sales]))

I have some specific information only on State A that other states can't sum on it.

[PijushRoy]

Hi @Henrique_Quint 

It depends on data model, can you please share the data model image?
If possible, share sample data for all table as excel format

[Henrique_Quint]

Hi, PijushRoy! I couldn't attach an excel file here, but here goes an image of a sample that I made, that's basically everything I'm using on this problem. Hope that it will be enough, is there anything more that you need?

[PijushRoy · Accepted solution]

Hi @Henrique_Quint 

Please find the PBIX file as an attachment. Please check the measures and data model.