I have created a measure to SUM the TotalValue per Region but agreggate by SUM the regions with the same Indicator.
MeasureWithProblem = CALCULATE(SUM(Table[TotalSale]); ALLEXCEPT(Table; Table[Indicator]))
Like the following image:
The measure really SUM the TotalValues when Indicator is equal, but if select one month on slicer the measure ignore the month too, like the following:
As you can see, the "MeasureWithProblem" always returns 255 for East and West when the correct is 85 when "feb" is selected.
Here a sample of data:
Tells DAX to remove the filters from every column of Table except [indicator] so it is removing the filter on data even when you slice on a month. Because the indicator is in your visual you should be able to use just
and get the anwer you are looking for.
Hey @jdbuchanan71 I already tried the simple SUM and it doesn't agreggate by sum where the Indicator column is equal
@gluizqueiroz So I guess you want to sym by indicator regardless the region difference right? If yes, try this one:
Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.
We spoke with Power BI Super User, Greg Deckler, about his charity work
Continue your learning in our online communities.