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

     

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.