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...
v-yalanwu-msft's avatar
v-yalanwu-msft
Community Support
4 years ago

Hi, Anonymous ;

You could try it.

Summary Trade Volume =
CALCULATE (
    TableA[Summary Net QTY] / 1000,
    FILTER (
        'TableA',
        [Date] = CALCULATE ( MAX ( Calendar[FiscalYear], ALLSELECTED ( Calendar ) ) )
    )
)

If not right, can you share a simple Scenario to explain your specific requirements ? More information make it easier to give you a solution. Looking forward to your reply.

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.