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.

Anonymous's avatar
Anonymous
Not applicable
10 months ago

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