Forum Discussion
Measure breaking with aggregation
Try this:
MyMax = CALCULATE(MAX('MarketingSnapshot'[DateStampMonth]),ALL('MarketingSnapshot'))You cannot put a measure in a filter. See this post though on creating a calculated table with what you need then using that table value to be your filter.
Or, you could create a calculated column in your table using the function Greg_Deckler gave as the column. Or create the value in Power Query as a caclulated column there and bring it into DAX that way.
Try this:
MyMax = CALCULATE(MAX('MarketingSnapshot'[DateStampMonth]),ALL('MarketingSnapshot'))
Thank you! This worked by itself, but do you know how I can put this in a Filter? I am getting the error saying too few arguments?
You cannot put a measure in a filter. See this post though on creating a calculated table with what you need then using that table value to be your filter.
Or, you could create a calculated column in your table using the function Greg_Deckler gave as the column. Or create the value in Power Query as a caclulated column there and bring it into DAX that way.
Got it, thank you!