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 tabla, el valor repetido "investigando y/o diseñando" es 48 en el recuento de fechas y para su estado. No sé cómo obtener esos datos en este momento.

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] )
    )
    )

     

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Anonymous ,

     

    I made a test from my sample data I created myself.

    The measure is this.

    Dup =
CALCULATE (
    SUM ( 'Table'[Work Hour] ),
    FILTER (
        ALLSELECTED ( 'Table' ),
        [Status] = MAX ( 'Table'[Status] )
            && [Change Status2] = MAX ( 'Table'[Change Status2] )
    )
)

     

     

     

    Best Regards,

    Stephen Tao

     

    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
      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

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Tell you that the Date column and the work hours column are personalized, the source of my dataset does not come, therefore, this option is not viable, I should do it through Dax, I have used this:
    MINX(
    TOPN (
    one,
    ADDCOLUMNS (
    VALUES ( SREs[Work Hour] ),
    "Frequency", CALCULATE ( COUNT ( SREs[Work Hour] ) )
    ),
    [Frequencies],
    0
    ),
    SREs[Work Hours]
    )
    __________________________________

    But it didn't work for me, because I have to evaluate by category, I should do that for each category I find the mode including the date.