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.
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% Cannot understand your requirement unless you share the file.
No problem thank you for helping me! I created a new measure to get the output I am looking for.