I created a new measure for Est. Revenue which works fine in the rows, but the Total shows the incorrect value.
In this case I tried with SUMX, but it doesn't work either.
Please check if these thread can be helpful.
Try to wrap a SUMMARIZE function within the SUMX function.
If it doesn't work ,please share a sample file for further research.
Community Support Team _ Eason
I created a column instead of a measure with DAX code below, then I added this column to the chart and total was 51451
Did it work ? 👌 Mark it as a solution to help spreading knowledge 👍 A kudos would be appreciated
@thhmez7 , if D selected is not selected slicer you can create you measure like
calculate(sum(project[est revenue]), filter(account,account[industry] <> "D")) +0
Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.
Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!
We had a great 2022 with a ton of feature releases to help you drive a data culture.