Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

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 = CALCULATE(TableA[Summary Net QTY]/1000, FILTER(Calendar, MAX([FiscalYear])))
3 REPLIES 3
v-yalanwu-msft
Community Support
Community Support

Hi,  @Anonymous ;

Is your problem solved?? If so, Would you mind accept the helpful replies as solutions? Then we could close the thread. More people who have the same requirement will find the solution quickly and benefit here. Thank you.

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.
v-yalanwu-msft
Community Support
Community Support

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.

ValtteriN
Super User
Super User

Hi,

Try this:


Summary Trade Volume =
var maxyear = CALCULATE(MAX([FiscalYear]),ALL(Calendar)) return
 
CALCULATE(TableA[Summary Net QTY]/1000ALL(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/





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.