If filter is "Multiple Values"?

[Rewind]

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 [Name] has Multiple selected calculate x

If the filter for [Name] has only one selected calculate y

[Zubair_Muhammad · Accepted solution]

@Rewind

Try HASONEVALUE or HASONEFILTER functions in DAX

SOmething like

=
IF ( HASONEVALUE ( Table1[Name] ), [Measure1], [Measure2] )

[v-jiascu-msft]

Hi @Rewind,

Could you please mark the proper answers as solutions?

Best Regards,

Dale

[v-jiascu-msft · Accepted solution]

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

[Zubair_Muhammad · Accepted solution]

@Rewind

Try HASONEVALUE or HASONEFILTER functions in DAX

SOmething like

=
IF ( HASONEVALUE ( Table1[Name] ), [Measure1], [Measure2] )