https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Help-with-SELECTEDVALUE-How-to-exclude-from-my-filter-condition/m-p/3736424#M145637 <P>[deleted]</P> Thu, 11 Jul 2024 13:46:09 GMT PBI12345 2024-07-11T13:46:09Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Help-with-SELECTEDVALUE-How-to-exclude-from-my-filter-condition/m-p/3736424#M145637 <P>[deleted]</P> Thu, 11 Jul 2024 13:46:09 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Help-with-SELECTEDVALUE-How-to-exclude-from-my-filter-condition/m-p/3736424#M145637 PBI12345 2024-07-11T13:46:09Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Help-with-SELECTEDVALUE-How-to-exclude-from-my-filter-condition/m-p/3736446#M145640 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="405068" data-lia-user-login="PBI12345" class="lia-mention lia-mention-user">PBI12345</a>&nbsp;Try this:</P> <LI-CODE lang="markup">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]) )</LI-CODE> Fri, 01 Mar 2024 14:18:09 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Help-with-SELECTEDVALUE-How-to-exclude-from-my-filter-condition/m-p/3736446#M145640 Greg_Deckler 2024-03-01T14:18:09Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Help-with-SELECTEDVALUE-How-to-exclude-from-my-filter-condition/m-p/3737308#M145688 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="313" data-lia-user-login="Greg_Deckler" class="lia-mention lia-mention-user">Greg_Deckler</a>&nbsp;worked perfectly! can't thank you enough for your help</P> Sat, 02 Mar 2024 01:54:39 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Help-with-SELECTEDVALUE-How-to-exclude-from-my-filter-condition/m-p/3737308#M145688 PBI12345 2024-03-02T01:54:39Z