How to Use Excluded Values from a Selection

[hlines_usacs]

Hello, I have a line chart with the dimensions and measure below. I also have 3 filters: Create Month, Create Week and Create Date.

Dimension: Service Month
Measure: SUM({<[Site Type]={'Yes'}>}Total_RVU)/Count({<[Site Type] = {'Yes'}>} DISTINCT Appointment_Id))

I was to add to the set analysis some logic that will use the excluded value selections from the Create Month, Week, and Date selections. For example, if I select January from the Create Month filter, I want my measure to reflect the excluded/alternative values of February, March, April, May, June, July, August, September, October, November, and December. 

Any ideas on how to accomplish that by adding to the additional set analysis I have in the measure?

Thanks!

[jwjackso · Accepted solution]

I think you should use the E() function

try something like SUM({<[Service Month]=E(),[Site Type]={'Yes'}>}Total_RVU)/Count({<[Site Type] = {'Yes'}>} DISTINCT Appointment_Id))