Forum Discussion
soumyaiyer
Helper IV
Helper IVMatrix table visual DAX for division
Hi, I have the below Matrix Table showing the data weekly for two groups. Need help with DAX to divide New Hire values/Tenured Values
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.
soumyaiyerHelper IV
Helper IVI have added a IF statement for the tenure days and created two groups Tenured and New Hire.
- Ashish_Mathur
Super User
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.
- soumyaiyer
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% - Ashish_Mathur
What problem do you face with the measures which i suggested?