Forum Discussion

pardeepd84's avatar
pardeepd84
Icon for Helper III rankHelper III
5 years ago
Solved

Calculate max value in row on matrix

Hi, I am trying to get the 'max' count in a row within a matrix. My matrix contains the following fields:       I now need to create a further calculation to find the 'max' for each provid...
Need Help
Tutorial Requests
  • V-lianl-msft's avatar
    V-lianl-msft
    5 years ago

    Hi pardeepd84 ,

     

    Based on your description, you want to display the maximum value in the matrix row.

    Be aware that DAX measure are based on row context and the matrix is a multidimensional model. As a result, the context in the matrix does not exactly match the context in the two-dimensional dataset.

     

    Best Regards,
    Liang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

pardeepd84 , Try a measure like

 

calculate(maxx(values(Table[Employee ID]), calculate(count(Table[Employee ID]))), removefilter(Table[Employee ID]))

telesforo1969's avatar
telesforo1969
Icon for Helper V rankHelper V
3 years ago

Thank you so much