Forum Discussion

Rewind's avatar
Rewind
Icon for Helper I rankHelper I
7 years ago
Solved

If filter is "Multiple Values"?

I'm very new to Power BI so apologies if this seems like an easy solution.   I'm not sure if the following is possible but ideally I'd like to create a new measure where.   If the filter for [Nam...
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    7 years ago

    Rewind

     

    Try HASONEVALUE or HASONEFILTER functions in DAX

     

    SOmething like

     

    =
IF ( HASONEVALUE ( Table1[Name] ), [Measure1], [Measure2] )
  • v-jiascu-msft's avatar
    v-jiascu-msft
    7 years ago

    Hi Rewind,

     

    What can we do with the no selected? It could be like this one.

     

    Measure 23 =
VAR total =
    CALCULATE ( COUNT ( DimProduct[ColorName] ), ALL ( DimProduct[ColorName] ) )
RETURN
    IF (
        HASONEVALUE ( DimProduct[ColorName] ),  // one selected.
        [Y],
        IF (
            COUNT ( DimProduct[ColorName] ) > 1
                && COUNT ( DimProduct[ColorName] ) < total,  //multi-selected.
            [X],
            [Other Measure]  // no selected.
        )
    )

     

    Best Regards,
    Dale

v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi Rewind,

 

Could you please mark the proper answers as solutions?

 

Best Regards,

Dale