Filter by repeat users

[brettg]

Hi All,

I'm trying to find a way to filter my report by repeat users.

As you can see in the image, I currently have a table which displays all tests, and a pie chart which displays a users lastest test between the date period on the slider.

The code I have in the text box is what I use to get the users latest test in the date range. Would it be possible to include in this measure a filter which only includes users that appear twice or more?

Thanks!

[v-yulgu-msft]

Hi @brettg,

Please try this:

latestdate2 =
VAR currGrade =
    SELECTEDVALUE ( 'Sample1'[Grade] )
VAR temp =
    ADDCOLUMNS (
        SUMMARIZE (
            FILTER (
                ALLSELECTED ( 'Sample1' ),
                CALCULATE ( COUNT ( Sample1[Test Date] ), ALLEXCEPT ( Sample1, Sample1[User] ) )
                    >= 2
            ),
            'Sample1'[User],
            "LastDate", MAX ( 'Sample1'[Test Date] )
        ),
        "Grade", LOOKUPVALUE (
            'Sample1'[Grade],
            'Sample1'[User], [User],
            'Sample1'[Test Date], [LastDate]
        )
    )
RETURN
    COUNTAX ( FILTER ( temp, [Grade] = currGrade ), [User] )

Best regards,

Yuliana Gu

[brettg]

Hi Yuliana,

Thanks for looking into this for me!

This measure does only include the users that have 2 or more tests. However, I don't think the user count is affected by the date slider?

On the image I have attached, Ben is included on the Pie chart with only 1 test in the time period. I know he has 2 tests in the whole period. Is it possible to capture the count of users between the date range, the same way MAX date is calculated?

Many thanks