Switch Function based on Different column Referenc...

RanjanThammaiah · ‎02-18-2020

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 · ‎02-18-2020

can you describe it with an example?

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast

Switch Function based on Different column Reference