Convert Simple Calculated Column Dax to Calculated Measure Dax

[Anonymous]

Table:

I created a Calculated Column as

Friendly BillAgentName =

IF('Bill agent'[billAgentName]="AP Green", "Green", IF('Bill agent'[billAgentName] = "AEP", "Ada Eco Plural"))

I will like to use a calculated measure instead of a Calculated column because I need to improve on perfromance of my Tabular Model.

Here is the anticipated result.

Result:

Can I have the Dax for the Calculated measure to accomplish same requirement?

[Seanan · Accepted solution]

Hi @Anonymous 

Please try this:

Switch = SWITCH(TRUE(),MAX('Table'[Names]) = "AP Green","Green",MAX('Table'[Names]) = "AEP","Ada Eco Plural")

Then if you have any values that return blank in the measure then enable "show items with no data"

Kind regards,
Seanan
If this post helped, please consider accepting it as the solution.