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 Var rev=Project[Est. Revenue]
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
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.