Forum Discussion

joepath's avatar
joepath
Icon for Helper II rankHelper II
3 years ago
Solved

Summarize stop working with Many to Many relationship

Hello, I have the below measure which was working fine with 1:M relationship, but due to some requirement we need to convert the relationship to M:M. now the measure stop working because its using ...
DAX
  • tamerj1's avatar
    tamerj1
    3 years ago

    joepath 

    Please try

    Test =
    SUMX (
    CROSSJOIN (
    CROSSJOIN ( VALUES ( user[full_name] ), VALUES ( city[name] ) ),
    VALUES ( country[country code] )
    ),
    VAR M1 = [M1] RETURN IF ( M1 >= 1, M1 )
    )

    but this will make it even slower

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

joepath 
And what is the dax fro the two measures?

joepath's avatar
joepath
Icon for Helper II rankHelper II
3 years ago

its simple sum.

  • tamerj1's avatar
    tamerj1
    Icon for Community Champion rankCommunity Champion
    3 years ago

    joepath 

    Hmm 🤔 

    can you please share a screenshot of your data model with relationships and advise which columns that are being summed.