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.

Gabry's avatar
Gabry
Super User
10 months ago

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.