cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
abhiram342
Microsoft
Microsoft

DAX measure on tables with no relationships

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

A1110
A2120
A3130

 

Geo Table: (Dimension)

GeoId    GeoName

1US
2UK
3Brazil

Subsidary Table:

SubId     SubName

1US

 

 

Output

SubName     Sales BYSub  Sales In-house

US6010

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

1 REPLY 1
amitchandak
Super User IV
Super User IV

@abhiram342 , Try a measure like

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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors