Help - Calculate the mode

[Anonymous]

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.

[v-stephen-msft]

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 · Accepted solution]

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

)

)

[Anonymous]

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.

[tom480]

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