Forum Discussion
Helper VMax Month formula does not work in tables
dapperscavenger This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376
Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907
Hi dapperscavenger ,
Could you please provide some sample data (exclude sensitive data) in table Switch UoM and Inventory? How did you set your visuals(which field or measure be applied on visual)? What's the calculation logic of your measure "UoM TM"? Please also provide the formula of measure SumValue,SumVolumeAC,SumVolumeEU and SumDistinctSKUs which are used for calculating sum value of different UoM type. Thank you. Later we will make troubleshooting based on these information and provide you the suitable formulas.
Best Regards
Rena
dapperscavengerAh. never mind, I figured out what it was doing.
Using the max month in a formula that way just isn't going to work, becaus it uses the max month where data is available for EACH ROW, rather than the max date that is available for the whole table.
I made a workaround by creating an indicator for max month in a separate column.