Switch statement creates a cross join. Want to understand ways to rectify issue

[PPerera]

Hi All

I have a WAVG metric created using following definition.

WA1 =

SUMX( 'public fsales',  'public fsales'[sales]*RELATED('public strrtg1'[rtgfactor]))

/

SUM('public fsales'[sales])

The definition involves two tables and a connection has established as shown below

'public fsales' [rtg] = 'public strrtg1' [rtg]

In 'public strrtg1'  , [rtg] and [rtgfactor] has 1 : 1 relationship

** When I add WA1 to a grid with other few attributes , no additional rows get produced so I do not notice a cross join effect.

I created a calculated measure in  'public strrtg1'  using SWITCH statemnet as shown below

WA2 = SWITCH (
TRUE,
'public fsales'[WA1] <=120 , "A+",
'public fsales'[WA1] <=175, "A",
'public fsales'[WA1] <=1500, "A-",

'public fsales'[WA1] <=2300, "B+",

'public fsales'[WA1] <=3400, "B",

'public fsales'[WA1] <=4100, "B-",

"N/A"
)

When I add WA2 to the grid with few attributes, large number of rows get generated and looks like it is doing a cross join 

Eg 1: no cross join 

Eg 2 : there is cross join

Please help me to solve this issue

Thank you

[samratpbi]

Hi,

Looking into the screenshot, it seems more number of rows is getting returned due to 1. you have introduced prodname column and also while calculating W2, you didnt handle blank. Add a condition when WA1 is blank.