Is possible to ignore row filter context in a table ?

[gg80]

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!

[gustavog80]

Hi, so, this is not possible ? I mean, not sounds so crazy, I just wanted to get the value selected in the filter, not depending on anyhing else, neither row context or context filter, sounds possible ? Should be simple but seems not is. 

[Anonymous]

Hi, @gg80

You can create a new measure and try the following dax : 

Selected = 
VAR currGroup = SELECTEDVALUE('Table'[Group Code])
RETURN
IF(
    ISBLANK(currGroup),
    CALCULATE(MAX('Table'[Group Code]), ALL('Table')),
    currGroup
)

Here is my preview:

How to Get Your Question Answered Quickly 

Best Regards

Yongkang Hua

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[gg80]

Hi Yohua! Thanks for your time. For some reason, I tried the soluttion propposed and still having same results, do you have some idea what could be the reason of this different behaviour ? :S

Additionally, when no value is selected on Group filter, "Selected" Measure still shows 3 on card, and 2 or 3 in the table: