Forum Discussion
Counting duplicat values
In this scenario, you can create a variable to get th count of visits for each user.
=CALCULATE(COUNTA(Table[VisitDate]),ALLEXCEPT(Table,Table[User]))
Then you can create a measure to filter users with more than 2 visits.
2 plus visits users = VAR CountOfVisits = CALCULATE ( COUNTA ( Table[VisitDate] ), ALLEXCEPT ( Table, Table[User] ) ) RETURN CALCULATE ( DISTINCTCOUNT ( Table[User] ), FILTER ( Table, CountOfVisits >= 2 ) )Regards,
In the CALCULATE you can add another FILTER => ALLSELECTED([Dates]
In this scenario, you can create a variable to get th count of visits for each user.
=CALCULATE(COUNTA(Table[VisitDate]),ALLEXCEPT(Table,Table[User]))
Then you can create a measure to filter users with more than 2 visits.
2 plus visits users =
VAR CountOfVisits =
CALCULATE ( COUNTA ( Table[VisitDate] ), ALLEXCEPT ( Table, Table[User] ) )
RETURN
CALCULATE (
DISTINCTCOUNT ( Table[User] ),
FILTER ( Table, CountOfVisits >= 2 )
)
Regards,
Thank you so much! This works except for when I put a slicer on my dashboard and filter for a specific date range. Any suggestions? Essentially, when I filter for certain open date ranges, I want my formulas to recalculate based on my specified date range. Thanks again for all the help.
CountofVisits = CALCULATE(COUNTA(Table[Open Date]),ALLEXCEPT(Table,Table[VIN]))
Count2+ = CALCULATE(DISTINCTCOUNT(Table[VIN]),FILTER(Table,[CountofVisits]>=2))
In the CALCULATE you can add another FILTER => ALLSELECTED([Dates]