Forum Discussion
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
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.
Cannot understand your requirement unless you share the file.
No problem thank you for helping me! I created a new measure to get the output I am looking for.