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
Customer Geo SubsidaryID Sales
Geo Table: (Dimension)
SubName Sales BYSub Sales In-house
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
@abhiram342 , Try a measure like
Sales BYSub = calculate(sumx( values(fact[SubsidaryID]), calculate(sum(fact[Sales]))), filter(Fact, fact[SubsidaryID] = max(Subsidary[SubID])))
Proud to be a Super User!
Check out new user group experience and if you are a leader please create your group!
Check out how to claim yours today!
Test your skills now with the Cloud Skills Challenge.