Forum Discussion
Solved
sum of max values
Hi everyone, I'm trying to sum the max values of some items from a table. I have generated an example table for explanation purposes: City Sales Bueno...
Alternative Sum of Max = SUMX(
SUMMARIZE(TableName, TableName[City], "Max Sales", MAX(TableName[Sales])),[Max Sales])
My first formula works on a test table I already had, but it doesn't seem to work right when I typed in your sample table. I can't figure out why that's the case because they both follow a similar pattern, but anyway this second formula works for both.
Danny2020
Helper I
Helper IHello,
What would be the DAX in a scenario with a second city table from which a city filter selection is added? With the formula provided the total is for all the cities, even if a single city is filtered. Thanks