Forum Discussion
Matrix table visual DAX for division
Then these measure patterns will work
T = calculate(sum(Data[Amount]),Data[Type] = "Tensured")
NH = calculate(sum(Data[Amount]),Data[Type] = "New Hire")
D = divide([T],[NH])
Hope this helps.
I have added a IF statement for the tenure days and created two groups Tenured and New Hire.
Then these measure patterns will work
T = calculate(sum(Data[Amount]),Data[Type] = "Tensured")
NH = calculate(sum(Data[Amount]),Data[Type] = "New Hire")
D = divide([T],[NH])
Hope this helps.
Hi,
The values for the New Hire and Tenured is the AHT in Total Seconds, am trying to divide the New Hire AHT seconds by Tenured AHT seconds week by week.
Eg : Week 41 -
689 580 The % should be
18.79% What problem do you face with the measures which i suggested?
Hi,
After creating the measure suggested, the % increase is not calculated as below. Need help how to use ABS function here to get the correct % increase.
Eg : Week 41 -
689 580 The % should be
18.79%