Help with SELECTEDVALUE: How to exclude from my filter condition if more than one value selected?

[PBI12345]

Hi,

In the below DAX, I am creating a measure with multiple filters. The last filter condition (bolded) is causing me issues.

AsAt Leisure Revenue LY =

CALCULATE(

    SUM(

        'Data: RADAR'[Revenue Held (LY)]),

            ALL('Booking Agents'),

            'Data: RADAR'[Source] = "AsAt",

            'Booking Agents'[Psuedo Segment Type] = "Leisure",

            'Network Group Table'[Network Group] = SELECTEDVALUE('Data: RADAR'[Network Group])

)

When only a single value for "Network Group" is selected in a slicer, the DAX works as intended. However, if muliple or no selections are made for "Network Group", the entire calculation returns "(Blank)".

If there are mutliple or no "Network Group" values selected, I instead want the entire final filter condition to be ignored, and have no filtering based on the selected value of "Network Group". 

I have tried using combinations of the IF, HASONEVALUE and also returning BLANK() as the alternate result, but nothing is working out.

A huge thanks in advance to anybody that can assist! 

[Greg_Deckler · Accepted solution]

@PBI12345 Try this:

AsAt Leisure Revenue LY =
CALCULATE(
    SUM(
        'Data: RADAR'[Revenue Held (LY)]),
            ALL('Booking Agents'),
            'Data: RADAR'[Source] = "AsAt",
            'Booking Agents'[Psuedo Segment Type] = "Leisure",
            'Network Group Table'[Network Group] IN DISTINCT('Data: RADAR'[Network Group])
)

[PBI12345]

@Greg_Deckler worked perfectly! can't thank you enough for your help