Hello!, Please I ask fro support in applying function for specific element DAX.
I Have a column called LOB, contains 11 elements "Criteria"
<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])
<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])
<tbody>
</tbody>
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>
Last edited: