Forum Discussion
Calculate repeate times
I wana calculat number of repeated id for who take mor than 120m
- Anonymous2 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
- danextian
Super User
Hi Eng-mohd ,
Can you please post a sample data that can be copy-pasted to Excel (not an image) and your expected result. Please refer to this sticky post on how to get your questions answered quickly - https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/3525139#M1163909
- AnonymousNot 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.