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 ChampionPlease 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.
