Ignore the slicer Item on dax function .

hi, Anonymous 

You could use ALL , ALLEXCEPT Function in dax formula to ignore the slicer like below:

Measure = 
IF (
    SELECTEDVALUE ( 'Table'[Customer_type] ) = "All",
    CALCULATE (
        SUM ( 'Table'[Value] ),
        FILTER ( ALL ( 'Table' ), 'Table'[Customer_type] = "Validated" )
    ),
    CALCULATE (
        SUM ( 'Table'[Value] ),
        FILTER ( ALL ( 'Table' ), 'Table'[Customer_type] = "All" )
    )
)

Result:

here is the sample pbix file, please try it.

Best Regards,

Lin

Hi,

Thanks for your respones.

I achived the above one by using "HASONEVALUE" function.

Ex: IF (HASONEVALUE('Table'[Customer_type] ), [Total_member],[validated_members])

its worked me well the way i wanted.