Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
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 Anonymous ,

     

    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

Anonymous , Try a measure like

 

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    amitchandak 

     

    amitchandak I tried this but it but this does not return the result I require.

     

    I'm not sure why I would use the remove filters option. Please could you advise.

    • V-lianl-msft's avatar
      V-lianl-msft
      Icon for Community Support rankCommunity Support
      5 years ago

      Hi Anonymous ,

       

      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.

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Hi V-lianl-msft 

         

        Thank you for your reply, I have used another method to calculate find this out.  

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

    Thank you so much