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 

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the community members for the issue worked. If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Thanks and regards

[v-nmadadi-msft]

Hi @FarquharG ,

As we haven’t heard back from you, we wanted to kindly follow up to check the status of your issue, if it is still unresolved, Kindly share some sample data so that we can take a closer look and try to assist you further

Thanks and regards

[Poojara_D12]

Hi @FarquharG 

Regional Measure = 
CALCULATE(
    SUM('AllData'[TotalInquiries]),
    ALL('AllData'[Organization]),
    FILTER(
        ALL('AllData'[Classification]),
        'AllData'[Classification] IN {"Class II", "Class III", "Class IV"}
    )
)

This version removes filters on Organization but only allows Class II, III, and IV to pass through in the Classification column. It ensures that your regional measure stays unaffected by organization-level filters but still respects specific classifications—exactly as intended in your use case.

[v-nmadadi-msft]

Hi @FarquharG ,
May I check if this issue has been resolved? If not, could you please share some sample data so we can investigate further and provide more targeted assistance.
Thank you

[v-nmadadi-msft · Accepted solution]

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.