Slicers not changing values in cards

[AMBP1973]

Hello everyone,

I have 4 slicers which should change the associated card, the values in these are all from the same table. When selecting from the 'Function' slicer the card value changes as expected, but when I change the 'Sub'function', 'Skill Grade, or 'Jobe Code' slicer/s they are not changing the 'Function' in the card which I would expect as they are in the same table row. I have got something simular working previously in another dashboard with diffrerent data, but can't figure out the issue here. Any advice would be much appreciated.

I have the following measure used on the card to show 'Nil Selection' if no slicer has bee selected:

Function - Nil Selection = IF(NOT(ISFILTERED('E&T Job Family 20230911'[Function Long Description])),"Nil Selected", ALLSELECTED('E&T Job Family 20230911'[Function Long Description]))

[AMBP1973]

@CoreyP the measure I am using on the card is 

Function - Nil Selection = IF(NOT(ISFILTERED('E&T Job Family 20230911'[Function Long Description])),"Nil Selected", ALLSELECTED('E&T Job Family 20230911'[Function Long Description]))

All the data is from the same table, therefore nil impact re' model. Unfortunately I cannot provide a sample of the raw data, but for example the associattion would be something like:

Function	Sub-function	Skill Grade	Job Code
Communications	Online Communications	Web Developer	Level 3 Webdevloper

Essentially all of the associated data is in the same row

[CoreyP]

I don't see anything in your measure that references any of the other columns. ( Sub-Function, Skill Grade, Job Code ) It only says if a selection is made in Function, show that value. Additionally, I don't think you can use ALLSELECTED to return a value for a card visual as ALLSELECTED will return multiple values, and I think a card will only display a singular value, not a list. Are you forcing single select in each of the slicers? Or are you wanting to have users be able to select multiple functions or sub-functions and have the list of all the values selected displayed?

[AMBP1973]

@CoreyP I have enabled 'single select'. Would you be able to advise on an appropriate measure to enable the term 'Nil Selected' when nothing has been selected, and return a result if any of the diffrent slicers are selected?

Thankyou in advance

[CoreyP]

This is kind of messy, and you likely won't want the additional commas so you may want to clean it up a bit. But something like this should do the trick. The other thing you could do is not use a card, and just use a table visual with separate measures so you could have something like:
Function: "Communications"
Sub-Function: "Nothing Selected"
Skill Grade: "Web Developer"
Job Code: "Nothing Selected"

Selections Card =

VAR _function = IF( ISFILTERED( Functions[Function] ) , MAX( Functions[Function] ) , BLANK() )

VAR _subfunction = IF( ISFILTERED( Functions[Sub-Function] ) , MAX( Functions[Sub-Function] ) , BLANK() )

VAR _skillgrade = IF( ISFILTERED( Functions[Skill Grade] ) , MAX( Functions[Skill Grade] ) , BLANK() )

VAR _jobcode = IF( ISFILTERED( Functions[Job Code] ) , MAX( Functions[Job Code] ) , BLANK() )

VAR _concat = COMBINEVALUES( ", " , _function , _subfunction , _skillgrade , _jobcode )

RETURN

IF( _concat = ", , , " , "Nothing Selected" , _concat )

[CoreyP]

Check out this video, you may find it useful or inspiring. I freaking love this dude: https://www.youtube.com/watch?v=QaOG42ic2wI

[AMBP1973]

Thanks Corey, that was very useful!

[CoreyP]

Can you show a sample of your raw data, and a screenshot of your model and the measure/fields you're using in the card visuals?