Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!
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
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
User | Count |
---|---|
139 | |
113 | |
104 | |
77 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |