apply function for specific element DAX

[Addora]

Hello!, Please I ask fro support in applying function for specific element DAX.

I Have a column called LOB, contains 11 elements "Criteria"

LOB

Business

Golden Customers

NC

Reapers

TEData-Sales

TEData-Sales "Subscription"

WE

Xceed-UP Q

Xceed-Basic

Xceed-Sales

<tbody>
</tbody>

I need to create a measure called AHT, but to be specified based on LOB, e.g

For Below LOBs I need to Use measure: AHT:=(((([Sum of ACD Time]+[Sum of ACW Time]+[Sum of Hold Time])-[Sum of ACWOUTOFFTIME])/86400)/[Sum of ACD Calls])

Business

Golden Customers

NC

Reapers

TEData-Sales

TEData-Sales "Subscription"

WE

<tbody>
</tbody>

but for below LOBs I need to apply this function to the same measure

AHT:=((([Sum of ACD Time]+[Sum of ACW Time]+[Sum of Hold Time])/86400)/[Sum of ACD Calls])

Xceed-UP Q

Xceed-Basic

Xceed-Sales

<tbody>
</tbody>

 

[FranzV]

You can solve this using a Lookup Table and a Calculated Column. Try the following steps:

• Add a table to your data model with LOB values that require the first measure.
  • I will call it FirstMeasureCriteria and it only has one column: LOB.
• Add a calculated column to your original table called RequiresFirstMeasure with the formula:
  • = CONTAINS( FirstMeasureCriteria , FirstMeasureCriteria[LOB] , YourTable[LOB] )
  • This will return TRUE if the LOB in the current row context can be found in the lookup table.
• Create one measure for each different calculation and name them FirstAHT and SecondAHT.
• Create the AHT measure that chooses between the two:
  • AHT:= IF( VALUES( YourTable[RequiresFirstMeasure] ) , [FirstAHC] , [SecondAHC] )

I hope it helps.