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