Forum Discussion
Counting Reoccurances.
Hi guys,
I am in need of help making a measure that marks each point in time an ID reoccurs. For example in the picture below i have 1 reoccurance of ID 1234 in which the ID repeats on the date Monday, July 01, 2013. I would like a measure that would log this and show a value of 1 at each date with a repeat ID.
Heres a link to the Power BI file and Excel File i am using; https://www.zeta-uploader.com/en/716253617
Hi Anonymous
If i undertsand you right, create measures as below
repeat = CALCULATE ( COUNT ( Sheet1[ID] ), FILTER ( ALL ( Sheet1 ), Sheet1[ID] = MAX ( Sheet1[ID] ) && [Date End] <= MAX ( Sheet1[Date End] ) ) ) show id = IF([repeat]>1,MAX(Sheet1[ID]),BLANK()) final show = IF([repeat]>1,1&" "&"ID:"&[show id])If not, please let me know more details.
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
You should be able to use EARLIER for this. See my article on Mean Time Before Failure (MTBF) which uses EARLIER: http://community.powerbi.com/t5/Community-Blog/Mean-Time-Between-Failure-MTBF-and-Power-BI/ba-p/339586
Hi Anonymous
If i undertsand you right, create measures as below
repeat = CALCULATE ( COUNT ( Sheet1[ID] ), FILTER ( ALL ( Sheet1 ), Sheet1[ID] = MAX ( Sheet1[ID] ) && [Date End] <= MAX ( Sheet1[Date End] ) ) ) show id = IF([repeat]>1,MAX(Sheet1[ID]),BLANK()) final show = IF([repeat]>1,1&" "&"ID:"&[show id])If not, please let me know more details.
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
