Forum Discussion
NotebookEnjoyer
Advocate II
Advocate IIUSERELATIONSHIP problems with n:m-relationship
Hello everyone, I have an arrangement as follows: Therein, the following measure unfortunately yields blank values: Sum by inactive Relationship = SUMX( VALUES('Fact_2'[Key_F2]), ...
Try this:
Sum F1 by F2 := CALCULATE( SUM('Fact_1'[Value_F1]), TREATAS( VALUES('Fact_2'[Key_D1]), 'Fact_1'[Key_D1] ), REMOVEFILTERS('Map1') )
NotebookEnjoyerAdvocate II
Advocate IIDoesn't work, unfortunately. Could it be that the calculated "_Keys"-table does not have the original relationships anymore?
FBergamaschi
Super User
Super Userlooks like we need a REMOVEFILTERS due to context transition, can you shar ethe pbix ?
Thanks
If this helped, please consider giving kudos and mark as a solution
@me in replies or I'll lose your thread
Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page
Consider voting this Power BI idea
Francesco Bergamaschi
MBA, M.Eng, M.Econ, Professor of BI
- NotebookEnjoyer
Unfortunately I can't, because the real model contains company data (and rebuilding the whole thing as mock-up does not yet seem proportional).