Measure to ignore filter | Slicer

[Invesco]

Hi Experts

I am trying to sum the occurance of CFD , but i want the summed value to ignore what is selected in the Filter | Slicer 

VAR Amt give me the corrcet value but when i select f2f from the select the value return 0 and so on...CFD are not in the slicer..

Days # =

VAR Amt = Calculate(SUM(Table1[data_value]),

FILTER(Table1,Table1[activity_type_1] ="customer_facing_day"))+0

VAR TotalAmt = CALCULATE(Amt,ALLEXCEPT(Table1,Table1[activity_type_1]))

Return

TotalAmt

Type	Data Value
f2f	1
phone	1
CFD	1
CFD	1
Phone	1
Virtual	1

[Samarth_18 · Accepted solution]

Hi @Invesco ,

Please try this:-

Days # =
CALCULATE (
    SUM ( Table1[data_value] ),
    FILTER (
        ALL ( Table1[activity_type_1] ),
        Table1[activity_type_1] = "customer_facing_day"
    )
) + 0

Thanks,

Samarth

[Invesco]

Thanks you sir you gave me a clue and i have fixed the solution

[Invesco]

HI Samarth - it ignores the filter but the sum of the CFD is incorrect know - should be 2....based on the date column....

[Samarth_18]

@Invesco Based on data provided below code would be ideal code:-

Days # = 
CALCULATE (
    SUM ( 'Table (5)'[Data Value] ),
    FILTER (
        ALL ( 'Table (5)'[Type] ),
       'Table (5)'[Type] = "CFD"
    )
) + 0

[Invesco]

apologies the CFD days does not remain at 2 when filtering the data in the table based on the sclier.....NOT WORKING MY ERROR...can you provide a pbix with the calculation