Need help with DAX code that includes only specific values

[FarquharG]

Hi everyone.

I have a dashboard that includes a bar chart and line chart that compares data from one organization versus the total of all the  organizations in the region. I need the regional data to not be affected by any other filters with one exception - specfic values in the classification column.

Here is my DAX code:

Regional Measure =

    CALCULATE(

        SUM('AllData'[TotalInquiries]),

        ALL('AllData'[Organization]),

        'AllData'[Classification] IN {"Class II", "Class III", "Class IV"}

    )

When I use this code, it includes all classifications instead of just the ones I listed above. How can I get this to work? 

[v-nmadadi-msft]

Hi @FarquharG ,

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information. Do not include anything that is unrelated to the issue or question.

Please show the expected outcome based on the sample data you provided.
Thank you

[FBergamaschi]

Can you please paste here some example of the table so we can reproduce the error? So we can import in Power BI and help you

[Greg_Deckler]

@FarquharG Try this:

Regional Measure =
  VAR __Table = FILTER( ALL( 'AllData' ), [Classification] IN {"Class II", "Class III", "Class IV" )
  VAR __Result = SUMX( __Table, [TotalInquiries] )
RETURN
  __Result

[FarquharG]

Hi Greg,

I added a "}" at the end of the first VAR line after "Class IV" because it was giving me an error. When I attempted the code, my regional numbers disappeared from the visuals.