How to calculate higher value for same dates on user level
I need to solve problem below presented: I am trying to calculate count of rows by unique users but problem is when user appears two or more times in same week. In example below, in #2 groups, 8-16 and 24 (highlighted in light-blue)
The output of this problem, in order to present number correctly should be like in unnammed column, meaning that if one user appears more that once in same week, I should count only the highiest group. In this case, for week 2022-11-26, only to consider group 24 as 1 and 8-16 as 0, so my easy countdistinct formula will show 7 instead of 8.
With small changes (ALLEXCEPT instead of ALL) I managed to get result + I added into FILTER User ID as my table contains 1000+ unique users (I just show here example for one). Overall, good guidance to what I wanted, so thank you. 👌
MAX ('Table'[Group rank]) =
MAX ('Table'[Group rank]),
FILTER (ALLEXCEPT('Table','Table'[Week Ending]), 'Table'[User ID] = SELECTEDVALUE('Table'[User ID]))),1,0)
But, with second measure, I have result i wanted for matrix viz, but when I want to show as chart (live printscreen below) and in Y-axis put measure 2, there is no values, why?