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 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'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

8 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    1 year ago

    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's avatar
      FarquharG
      Frequent Visitor
      1 year ago

      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.

  • FBergamaschi's avatar
    FBergamaschi
    Super User
    1 year ago

    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

  • v-nmadadi-msft's avatar
    v-nmadadi-msft
    Community Support
    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

  • v-nmadadi-msft's avatar
    v-nmadadi-msft
    Community Support
    1 year ago

    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

  • 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.

     

  • v-nmadadi-msft's avatar
    v-nmadadi-msft
    Community Support
    1 year ago

    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

     

  • v-nmadadi-msft's avatar
    v-nmadadi-msft
    Community Support
    1 year ago

    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