Forum Discussion
Matrix 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.
10 Replies
Hey buddy,
I’m not entirely sure how your data is structured or what your desired output is, but take a look at the PBIX file, it might help clarify things.Hi,
If new hire and tenured are measures that you have written, then write this measure
Measure = divide([new hired],[tenured])
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%
Hi soumyaiyer,
Thank you for reaching out to the Microsoft Fabric Forum Community, and special thanks to Gabry and Ashish_Mathur for prompt and helpful responses.
Just following up to see if the Response provided by community members were helpful in addressing the issue. if the issue still persists Feel free to reach out if you need any further clarification or assistance.
Best regards,
Prasanna Kumar
