Measure fetch 2 values from slicer

[PBI_newuser]

Hi,

I need to select 2 values from slicer to populate the correct value.

How to modify the measure to the below selectedvalue?

[Product]	Slicer [Country]	Slicer [ Name]
Product A	US	Product A
Product B	US	Product B
Product C	Canada

Measure =
IF(
    ISFILTERED(Slicer[Name]),
    SWITCH(
        SELECTEDVALUE(Slicer[Name]),
        "Product A",CALCULATE(MAX([Value]),FILTER('Table',[Product]="Product A")),
        "Product B",CALCULATE(MAX([Value]),FILTER('Table',[Product]="Product B")),
        "Product C",CALCULATE(MAX([Value]),FILTER('Table',[Product]="Product C"))),
    CALCULATE(MAX([Value]),FILTER('Table',[Product]="All")))

[v-shex-msft · Accepted solution]

Hi @PBI_newuser,

Perhaps you can try the following measure formula if it meets your requirement:

Measure =
CALCULATE (
    MAX ( [Value] ),
    FILTER (
        ALLSELECTED ( 'Table' ),
        IF (
            ISINSCOPE ( Slicer[Country] ),
            [Country] IN VALUES ( Slicer[Country] ),
            [Country] = "All"
        )
            && IF (
                ISINSCOPE ( Slicer[Name] ),
                [Name] IN VALUES ( Slicer[Name] ),
                [Name] = "All"
            )
    )
)

Regards,

Xiaoxin Sheng

[amitchandak]

@PBI_newuser , Try a measure like

Measure =
IF(
    ISFILTERED(Slicer[Name]) || ISFILTERED(Slicer2[Name]) ,
    CALCULATE(MAX([Value]),FILTER('Table','Table'[Product]  in allselected(Slicer[Name])  && 'Table'[COUNTRY]  in allselected(Slicer2[Name]) )))

[amitchandak]

@PBI_newuser , Not able to relate what is raw data, What are the slicers? Are slicer independent so we need handle. What is final outcome needed

[PBI_newuser]

@amitchandak this is an issue arised from the below topic.
https://community.powerbi.com/t5/Desktop/Slicer-for-all-products/m-p/1488926#M618213

I have 2 slicers for user to select which are "Country" and "Name".
How can I include these 2 fields in the "SELECTEDVALUE" function?