in Powerbi grouping different dimensions in 1 slicer and then filtering table

[Khushi]

We have a fact Table Transaction which has keys from various Dimensions

FactTransactionKey	DimProductID	DimAreaID	DimProgramID	Amount
1	1	1	1	10
2	1	2	2	20
3	2	3	3	30

Now In DIMProgram table we have

DimProgramID	PrgramName
1	AA
2	AB
3	AZ
4	AS

Similarly we have DimArea And DimProduct table

Now i want a slicer which is Multiselect but its values are 

Select ALL

Program

Area

Product

None

now if user select any items from Slicer Fact table should be filtered.
and we have rule like 

User selected Program and Area,
So we need to filter table based on Program and Area where Program name in ('AA','Ab') and AreaCode in ('aa',bb')

and if user select none

then 

we need to filter table based on Program and Area where Program name in ('AZ','AS') and AreaCode in ('cc',dd')

[Khushi]

NOt sure but below works without IF

FilteredAmount = VAR SelectedOptions = CONCATENATEX(ALLSELECTED(SlicerTable), SlicerTable[MeasureName], ",")

VAR FilteringValues
=       { "AA", "AB", "AZ", "AS"  },

RETURN

CALCULATE ( SUM(FactTransaction[Amount]),

FILTER ( FactTransaction, FactTransaction[DimProgramID] IN FilteringValues
) )

But IF is added it failes at bold giving error that ( function expect a table expression for argument ", but a string or numeric is passed), 😞

FilteredAmount = VAR SelectedOptions = CONCATENATEX(ALLSELECTED(SlicerTable), SlicerTable[MeasureName], ",")

VAR FilteringValues
=

IF(

        CONTAINSSTRING(SelectedOptions, "Prgram") && CONTAINSSTRING(SelectedOptions, "None"),

        { "AA", "AB", "AZ", "AS"  },

        IF(

            CONTAINSSTRING(SelectedOptions, "Prgram"),

            { "AA", "AB" },

            IF(

                CONTAINSSTRING(SelectedOptions, "None"),

                { "AZ", "AS" },

                { "AA", "AB", "AZ", "AS"  }

            )

        )

    )

RETURN

CALCULATE ( SUM(FactTransaction[Amount]),

FILTER ( FactTransaction, FactTransaction[DimProgramID] IN FilteringValues
) )

[mlsx4]

Hi @Khushi 

This video may help you: https://www.youtube.com/watch?v=HEP8FwYN9AQ

[Khushi]

Thanks for the response but In my slicer , user can select MUltiple values.
And also I am struck as I am trying to use below , but doesnt work

FilteredAmount = VAR SelectedOptions = CONCATENATEX(ALLSELECTED(SlicerTable), SlicerTable[MeasureName], ",")

VAR ProgramToFilter = IF ( CONTAINSSTRING(SelectedOptions, "Program"),

CALCULATETABLE(Program, Program[Code] IN {"AA", "AB"}),

IF ( CONTAINSSTRING(SelectedOptions, "None"),

CALCULATETABLE(Program, Program[Code] IN {"AZ", "AS"}),

ALL(Program) ) )

RETURN

CALCULATE ( SUM(FactTransaction[Amount]),

FILTER ( FactTransaction, FactTransaction[DimProgramID] IN VALUES(ProgramToFilter[DimProgramID]) ) )