Forum Discussion

FarquharG's avatar
FarquharG
Frequent Visitor
1 year ago
Solved

Need help with DAX code that includes only specific values

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 dat...
  • v-nmadadi-msft's avatar
    v-nmadadi-msft
    1 year ago

    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

Poojara_D12's avatar
Poojara_D12
Super User
1 year ago

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.