Forum Discussion

PBI12345's avatar
PBI12345
Icon for Helper I rankHelper I
2 years ago
Solved

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

[deleted]
  • Greg_Deckler's avatar
    2 years ago

    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])
    )