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 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!

Need Help

2 Replies

  • 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