Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Help - Calculate the mode

necesito calcular la moda o el valor que mas se repite dependiendo de la categoria o estado que tenga en mi tabla por ejemplo quiero calcular su moda para cada estado   Para mi ejemplo de tab...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Good morning, I did what you told me but it didn't work for me I attach my complete file so you can review it and tell me what mistake I'm making. Archivo  The document is in the file link.

     

    CALCULATE (
    SUM (Hoja1[Work Hour]),
    FILTER (
    ALLSELECTED (Hoja1),
    [issues.changelog.histories.items.fromString]= MAX ( Hoja1[issues.changelog.histories.items.fromString] )
    && [Change Status2] = MAX ( Hoja1[Change Status2] )
    )
    )

     

tom480's avatar
tom480
Resolver I
4 years ago

Hi Anonymous ,

 

Check this solution and see if it works.  1) Here I am doing a group by with status and date which duplicate the results of a matrix tile.  2) Next I just create a copy of the values column 3) And last step, I keep duplicates.  

 

You can see the results in Matrix tile (last screenshot) that gives you the duplicated values by status.  

 

If this works for you, please mark as a solution and help others know it worked for you!  Adios!  Tomas