Forum Discussion

soumyaiyer's avatar
soumyaiyer
Helper IV
10 months ago
Solved

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    
Need Help
Show and Tell
  • Ashish_Mathur's avatar
    Ashish_Mathur
    10 months ago

    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.

Ashish_Mathur's avatar
Ashish_Mathur
Super User
10 months ago

Hi,

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

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