Is possible to ignore row filter context in a table ?
Hi! I have found various similar issues to this one in the forum but no one of solutions provided works for me 😞 I need for some calculations in a table, the value of the selected value in Group filter. It works OK in a card (as displayed in screenshot attached) , but, when I tried to use it in a table, it change between 2 and 3 (you can see in the table in the screenshot), I understand this is due to the row context filter is being applied to the measure. I need that the value "Selected Group" in my table remains being 3 (the one selected) not depending on row context filter, hoy can I reach that ? I tried with ALL, ALLSELECTED combinations with no success at all Currently my "Selected Group" Measure looks like: Selected Group = VAR currGroup = MAX('Table'[Group Code]) RETURN CALCULATE( MAX('Table'[Group Code]), FILTER ( ALLSELECTED('Table'), 'Table'[Group Code] = currGroup ) ) Thansk in advance!
Ignoring a field filter but still wanting to sort on that field...
Hi all, I've been struggling with this and my knowledge of DAX obviously isn't up to task, so I'm hoping someone here can point me in the right direction.... DESIRED OUTCOME I want to create a tooltip that shows a graph of time booked (man hours from timelogging data) across months. Here's an example of the tooltip I'd like to see... CHALLENGE The challenge I'm having is that on the page that the tooltip should be linked from, has a filter on a specific [Month]. I don't want the month filter to persist through to the tooltip as I want to see all months, but other filters should persist. DATA STRUCTURE Here is an indication of the data structure I have (table and field names are correct)... I've tried various DAX CALCULATE syntax but no luck so far. Thanks in advance....
