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

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.