Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |