Switch Function based on Different column Reference

[RanjanThammaiah]

Hi All,

Hope you're ll doing good.

Just wanted to check if i can modify the below formula to switch for the differenct columns in differnt tables.

Currently its suming only for the Account name. I have differnt columns like. ServiceLine,Sector,MarketSegment.

Advisory SLI = VAR AdvSLI= IF([Advisory %]>0.1,1,0)

return

IF(HASONEVALUE(SLI[AccountName]),

AdvSLI,

SUMX(VALUES(SLI[AccountName]),AdvSLI))

Regards,

Ranjan

[mwegener]

Hi @RanjanThammaiah ,

can you describe it with an example?