if formula linked to ChicletSlicer

[andywil456]

I'm trying to create card that will show a Target % range that will change per employee. 

Eg table 

DAWN	25 - 30%
GEOFF	25 - 30%
JAN	25 - 30%
LYDIA	25 - 30%
PHERETHA	25 - 30%
VANESSA	25 - 30%
HARSHEET	18 - 25%
SAM	18 - 25%
Company	23 - 28%

The problem i face is when i de-select an employee or select more than 1 employee how do i get the card to default to the company % range?

[Vvelarde]

hi @andywil456

Use this Dax 

TheTarget =
IF (
    HASONEVALUE ( Table1[Name] ),
    VALUES ( Table1[Target] ),
    CALCULATE ( VALUES ( Table1[Target] ), Table1[Name] = "Company" )
)

[andywil456]

HI @Vvelarde

I have applied your Dax and it works when i select an employee, but when i de-select i get  (blank)  amount. 

TheTarget = IF ( HASONEVALUE ( 'July +'[Operator]), VALUES ( TARGETS[TARGET CONVERSION RANGE] ), CALCULATE ( VALUES ( TARGETS[TARGET CONVERSION RANGE]), 'July +'[Operator] = "Company" ) )

[Vvelarde · Accepted solution]

@andywil456

you have a page filter or report filter?.

Because don't see Company in your chiclet. If the answer is yes, the result is blank because Company was ignore in your report.