Forum Discussion

Eng-mohd's avatar
Eng-mohd
Icon for Helper I rankHelper I
2 years ago
Solved

Calculate repeate times

I wana calculat number of repeated id for who take mor than 120m

 

 

  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Eng-mohd 

    I think I understand what you mean:

    You want to calculate the actual quantity over 120 minutes, which includes duplicate values.

    Here's my solution:

    I created a table following the sample data you gave:

    Then create a measure:

    ----------------------------------------------

    Number = CALCULATE(SUMX('Table',[real class]),FILTER('Table','Table'[min]>120))

    ----------------------------------------------

    The meaning of this code is to sum the number of IDs corresponding to the part of the table with min greater than 120.

    The final result is as follows:

    Best Regards,

    Zhengdong Xu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Eng-mohd 

    I think I understand what you mean:

    You want to calculate the actual quantity over 120 minutes, which includes duplicate values.

    Here's my solution:

    I created a table following the sample data you gave:

    Then create a measure:

    ----------------------------------------------

    Number = CALCULATE(SUMX('Table',[real class]),FILTER('Table','Table'[min]>120))

    ----------------------------------------------

    The meaning of this code is to sum the number of IDs corresponding to the part of the table with min greater than 120.

    The final result is as follows:

    Best Regards,

    Zhengdong Xu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.