Counting Reoccurances.

[Anonymous]

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

[v-juanli-msft · Accepted solution]

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.

[Greg_Deckler]

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/3395...