DAX measure on tables with no relationships

[abhiram342]

Hi All,

Hope everyone doing good! I have below tables and looking for below DAX measures for tables with no relation ship. can you please help on the Code

Fact Table:

Customer Geo          SubsidaryID  Sales

A	1	1	10
A	2	1	20
A	3	1	30

Geo Table: (Dimension)

GeoId    GeoName

1	US
2	UK
3	Brazil

Subsidary Table:

SubId     SubName

1

US

Output

SubName     Sales BYSub  Sales In-house

US

60

10

Measure1: SalesBySubsidary: It's US in above Case: 10+20+30 =60

Measure2: Sales In house ( Geo(US) ==Subsidary(US) ) =10

Note: there is no relationship between Geo and Subsidary Table

I have issue with Region In-house, used treatas function but it's not giving correct result

Thanks,

Abhiram

[amitchandak]

@abhiram342 , Try a measure like

Sales BYSub =
calculate(sumx( values(fact[SubsidaryID]), calculate(sum(fact[Sales]))), filter(Fact, fact[SubsidaryID] = max(Subsidary[SubID])))