Forum Discussion
PBI12345
Helper I
2 years agoHelp with SELECTEDVALUE: How to exclude from my filter condition if more than one value selected?
[deleted]
- 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]) )
Greg_Deckler
Community Champion
2 years agoPBI12345 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])
)- PBI123452 years ago
Helper I
Greg_Deckler worked perfectly! can't thank you enough for your help