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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
dragonus
Helper III
Helper III

How do I show the Latest Value & Filter for only one section of the data?

I wanted to show the latest value of a table and only the 1 Month Returns value. My current measure is below and it returns me an error.

 

Latest = CALCULATE(SUM('Tech'[Value]),AND(FILTER(Tech,'Tech'[Date] = MAX('Tech'[Date])), FILTER(Tech,'Tech'[Metric] = "1 Month Returns")))

 

Consider my Table:

 

DateMetricValue
01/01/20201 Month Returns20201
01/01/20202 Month Returns1213
01/01/20203 Month Returns13423
01/01/20204 Month Returns2313

 

Would just like to show the "1 Month Returns" data when I use my measure

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@dragonus , Try

calculate(lastnonblankvalue(Table[Date],sum(Table([Value]))),Table[Metric] ="1 Month Returns")

or

calculate(lastnonblankvalue(Table[Date],max(Table([Value]))),Table[Metric] ="1 Month Returns")

View solution in original post

1 REPLY 1
amitchandak
Super User
Super User

@dragonus , Try

calculate(lastnonblankvalue(Table[Date],sum(Table([Value]))),Table[Metric] ="1 Month Returns")

or

calculate(lastnonblankvalue(Table[Date],max(Table([Value]))),Table[Metric] ="1 Month Returns")

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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