Measure to calculate a static line disappears when filter selected and calculate a KPI

[Anonymous]

Hi, 

I have 2 questions around the thing I'm trying to do. 
I have measure which is correct which calculates the coverage (%) for those with a certain column value: 

CCG Screening Coverage = DIVIDE(

CALCULATE(

SUM('Screening'[Eligible]),'Screening'[Area Code] = "E38000068"),

CALCULATE(

SUM('Screening'[Screened]), 'Screening'[Area Code] = "E38000068")

)

This should be static as the area average however when I choose a smaller area on a slicer within that area the line disappears and I'd like it to stay put.


also, I'm trying to calcualte the number of people needed in order to reach a target. I have a Switch statement :

Screening Target = SWITCH(

SELECTEDVALUE('Cancer Screening'[Screening Type]),

"Cervical Cancer", .8,

"Bowel Cancer", .6,

"Breast Cancer", .7

which changes a static line depending on what value is picked to show a target %. 

 I want a measure to multiple the above by those Eligible, take that figure away from those actually screened, to then leave me with the value I need. 

any ideas? 

[v-easonf-msft · Accepted solution]

Hi, @Anonymous 

If you want the constant line to be unaffected by slicers, it is recommended to use the ALL function  to ignore any filters that might have been applied. 

CCG Screening Coverage =
DIVIDE (
    CALCULATE (
        SUM ( 'Screening'[Eligible] ),
        FILTER ( ALL ( 'Screening' ), 'Screening'[Area Code] = "E38000068" )
    ),
    CALCULATE (
        SUM ( 'Screening'[Screened] ),
        FILTER ( ALL ( 'Screening' ), 'Screening'[Area Code] = "E38000068" )
    )
)

Best Regards,
Community Support Team _ Eason