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

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