Forum Discussion
Solved
Sum values by dynamic month
Hi everyone, I am new to power bi and trying to build a measure that will allow me to sum the total value by month dynamically and return the max value for that person. Can anyone help, please! ...
Hi Jarodp42 ,
You can use this measure and put it into a table visual together with the names: (I called my table Names btw):
Measure = VAR _groupedTable = SUMMARIZE(Names, Names[MonthYear], "SUM", SUM(Names[Values])) RETURN MAXX(_groupedTable, [SUM])Result:
You can put this measure into the Gauge target lable, but remember that it will be evaluated for the current data context. So, with your sample data, it will evaluate to 850 but not because Gaby has the highest, but because the month Sept-19 is overall the highest.
let me know if this answers your question 🙂Kind regards
Djerro123
-------------------------------
If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.
Keep those thumbs up coming! 🙂
Create a Max column like the one you have. (Mine was this)
Measure =
CALCULATE(
SUM('Table'[Values]),
ALLEXCEPT('Table','Table'[MonthYear],'Table'[Names]))
If you choose Max of Measure in the Values Fields section as well as the Names column you will be given the values you want on the the visualizaitons