Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Problem with measure

Hi, I am trying to create a meaurse were I am adding something and filter it to only show the max fiscal year but the filter isn't working. Any Idea what is going on ?    Summary Trade Volume = C...
ValtteriN's avatar
ValtteriN
Community Champion
4 years ago

Hi,

Try this:


Summary Trade Volume =
var maxyear = CALCULATE(MAX([FiscalYear]),ALL(Calendar)) return
 CALCULATE(TableA[Summary Net QTY]/1000, ALL(Calendar),Calendar[FiscalYear]=maxyear)

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/