Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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 Mond...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    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.

v-juanli-msft's avatar
v-juanli-msft
Community Support
7 years ago

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.