Forum Discussion

NotebookEnjoyer's avatar
NotebookEnjoyer
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]),    ...
  • Abdullahmajid1's avatar
    Abdullahmajid1
    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')
)
cengizhanarslan's avatar
cengizhanarslan
Super User
4 months ago

Please try the measure below:

Sum by inactive Relationship =
VAR _Keys =
    VALUES( 'Fact_2'[Key_D1] )
RETURN
    CALCULATE(
        SUM( 'Fact_1'[Value_F1] ),
        TREATAS( _Keys, 'Dim_1'[Key_D1] )
    )
NotebookEnjoyer's avatar
NotebookEnjoyer
Advocate II
4 months ago

Unfortunately this doesn't differentiate correctly for D1.