Matrix table visual DAX for division

[soumyaiyer]

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

[v-pgoloju]

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

[soumyaiyer]

I have added a IF statement for the tenure days and created two groups Tenured and New Hire.

[Ashish_Mathur · Accepted solution]

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?

[soumyaiyer]

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%

[Ashish_Mathur]

Cannot understand your requirement unless you share the file.

[soumyaiyer]

No problem thank you for helping me! I created a new measure to get the output I am looking for. 

[Ashish_Mathur]

Hi,

If new hire and tenured are measures that you have written, then write this measure

Measure = divide([new hired],[tenured])

[Gabry]

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.