I have a dataset with student Id , test date, test venue, test slot. A Student can have more than one test date with a different venue(nyc,la,..) and slot(a,b,c..)
I have slicers for venue and slot.
And i need to visualise the venue and slot distribution but only for the first test dates for each student.
I have a dynamic rank measure .
rank=Countx(filter (allselected[table]),[student Id]=max([student Id]) && [test date]<=max([test date])),[test date])
And count of first tests
Calculate(count(test date), filter (table, [rank]=1)
Everything works in a card.
But when I take it into a table visual with venue and first test count I am not able to get the venue distribution of the first tests I am only getting the count of first tests for each venue if that venue was the only option.
Tldr. In a table visual, The row context always gets applied first and then it applies my dynamic rank logic.
How do I make power bi apply my dynamic rank logic first and then apply the row context to the ranked values.
I want a table which shows
Summarize(filter(table,[rank]=1),count([test date])) is there a way to directly visualise this table in a visual. I can get this in dax studio but not in power bi as a dynamic visual that changes with slicers.
When I am trying to apply this filter through the filter pane onto the visual with venue and count of test dates everything disappears.
