Forum Discussion

KatkaS's avatar
KatkaS
Icon for Post Patron rankPost Patron
4 years ago

Summary on distinctcount..

Dears

 

I would need to calculate summary of the column D (number of rec), but I need to take in consideration Column F - they can be repeated, so to distinguish the Request IDs...

 

Could you please help with the measure please?

I then use it to visualise it in clustered column chart to see the trend per period.

Thank you very much!

 

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi KatkaS ,

     

    If you want to sum by grouping by request ID, you can create the following measure

    Summary =
CALCULATE (
    SUM ( 'Table'[number of rec] ),
    FILTER ( ALLSELECTED ( 'Table' ), [request ID] = MAX ( 'Table'[request ID] ) )
)

     

    If not, please provide me with the corresponding expected result.

     

     

    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.