topic Re: Need help with DAX code that includes only specific values in DAX Commands and Tips

Need help with DAX code that includes only specific values

FarquharG — Tue, 01 Jul 2025 18:22:37 GMT

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?

Re: Need help with DAX code that includes only specific values

Greg_Deckler — Tue, 01 Jul 2025 18:29:58 GMT

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

Re: Need help with DAX code that includes only specific values

FBergamaschi — Tue, 01 Jul 2025 18:31:48 GMT

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

Re: Need help with DAX code that includes only specific values

FarquharG — Tue, 01 Jul 2025 19:08:24 GMT

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.

Re: Need help with DAX code that includes only specific values

Anonymous — Wed, 02 Jul 2025 07:30:19 GMT

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

Re: Need help with DAX code that includes only specific values

Anonymous — Mon, 07 Jul 2025 08:51:02 GMT

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

Re: Need help with DAX code that includes only specific values

Poojara_D12 — Mon, 07 Jul 2025 12:36:32 GMT

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.

Re: Need help with DAX code that includes only specific values

Anonymous — Thu, 10 Jul 2025 12:01:52 GMT

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

Re: Need help with DAX code that includes only specific values

Anonymous — Fri, 11 Jul 2025 18:25:33 GMT

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