Forum Discussion
Solved
Total for Max Month
I have a power bi table visual that looks like this(link) When I try to calculate the Total Cost for Max available month, the calculation automatically reverts to the last month (YY-MMM) with data ...
- Measure = CALCULATE(sum(TOTALTRY[Total]),filter('Date','Date'[Month]= MAX('Date'[Month])))
Try this one, you need to do sum first then apply filter on monthnote: if date is from same table
Measure = CALCULATE(sum(TOTALTRY[Total]),filter('TOTALTRY','TOTALTRY'[Month]= MAX('TOTALTRY'[Month])))
Measure = CALCULATE(sum(TOTALTRY[Total]),filter('Date','Date'[Month]= MAX('Date'[Month])))
Try this one, you need to do sum first then apply filter on month
note: if date is from same table
Measure = CALCULATE(sum(TOTALTRY[Total]),filter('TOTALTRY','TOTALTRY'[Month]= MAX('TOTALTRY'[Month])))
this is the one I used. I used the filter inside calculate. Thank you so much!
