Forum Discussion

NotebookEnjoyer

Icon for Advocate II rank

Advocate II

4 months ago

Solved

USERELATIONSHIP 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]), ...

4 months ago

Try this:

Sum F1 by F2 :=
CALCULATE(
    SUM('Fact_1'[Value_F1]),
    TREATAS(
        VALUES('Fact_2'[Key_D1]),
        'Fact_1'[Key_D1]
    ),
    REMOVEFILTERS('Map1')
)

Icon for Super User rank

Super User

4 months ago

Hi NotebookEnjoyer

looks 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

Icon for Advocate II rank

Advocate II

4 months ago

Unfortunately I can't, because the real model contains company data (and rebuilding the whole thing as mock-up does not yet seem proportional).