Forum Discussion

brettg's avatar
brettg
Helper II
7 years ago

Filter by repeat users

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 la...
Need Help
v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
7 years ago

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's avatar
brettg
Helper II
7 years ago

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