SUMX with FILTER returning blank values in scatter plot

[Anonymous]

Hi there PBI Community!

I am trying to create a measure that sums up the values in one column, after applying two filters on another column. I am using this formula as the y-axis for a scatter plot:

Y-Axis Values = SUMX(FILTER ('Financial_Table', 'Financial_Table'[Category] = "Promotions" && 'Financial_Table'[Category] = "Discounts"),'Financial_Table'[Value])

The problem is that this formula is returning blank values (no values) on the scatter plot. Is there another way I could sum up the values in one column and apply two filters to another column within a DAX formula?

[v-jingzhang · Accepted solution]

@Anonymous If you want to sum up the values with Category "Promotions" and "Discounts", please replace "&&" with "||" in your DAX formula like below.

Y-Axis Values = SUMX(FILTER ('Financial_Table', 'Financial_Table'[Category] = "Promotions" || 'Financial_Table'[Category] = "Discounts"),'Financial_Table'[Value])

Community Support Team _ Jing Zhang
If this post helps, please consider Accept it as the solution to help other members find it.

[Anonymous]

You filter financial table WHERE Category = promotion AND Category = Discounts

I dont think you can have 1 record where both checks are true