Forum Discussion
joepath
Helper II
Helper IISummarize 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 ...
tamerj1
Community Champion
Community ChampionHi joepath
Please try
Test =
SUMX (
FILTER (
ADDCOLUMNS (
CROSSJOIN ( VALUES ( user[full_name] ), VALUES ( city[name] ) ),
"@M1", [M1]
),
[@M1] >= 1
),
[@M1]
)
joepathHelper II
Helper IIThanks tamerj1 for looking into this, seems working but performance is very slow can we do somthing about it?
And I have 3 col so should do like Crossjoin(values(Full_Name),values(city[name]), Country[code]) ?
- tamerj1
Please try
Test =
SUMX (
CROSSJOIN ( VALUES ( user[full_name] ), VALUES ( city[name] ) ),
VAR M1 = [M1] RETURN IF ( M1 >= 1, M1 )
)this will save the FILTER iteration but the price is paid by the IF condition. However, most probably it will be faster.