how to select multiple values from the result of slicer

[Anonymous]

Hi guys,

    I created a merseaur to switch the results of the each columns, for example, if I select "M', then the result of the measure is select the result of column related with 'exclusive_sourcing_firm_m'.

    It is easy when make a single choice, but how should the code be write when multiple choices selected? For example, the choice is "M+1" and "M+2", how should I write to capture these values and return the sum of "

exclusive_sourcing_firm_m1" + "exclusive_sourcing_firm_m2" ?

[v-kkf-msft]

Hi @Anonymous ,

Has your problem been solved? If it is solved, please mark a reply which is helpful to you.

If the problem is still not resolved, please try the following formula:

Measure = 
IF (
    CALCULATE (
        DISTINCTCOUNT ( FactTable[Type] ),
        FILTER (
            ALLSELECTED ( FactTable ),
            FactTable[Product] = MAX ( FactTable[Product] )
        )
    )
        = DISTINCTCOUNT ( Slicer[Name] ),
    1
)

Best Regards,
Winniz

[Samarth_18]

Hi @Anonymous ,

Please refer below article. It helped me, hope it helps you too.

https://www.sqlbi.com/articles/apply-and-logic-to-multiple-selection-in-dax-slicer/ 

Thanks,

Samarth

[Anonymous]

Thanks, good case.