Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.
Hi there,
I'd like to calculate the following in a measure (see screenshot):
Solved! Go to Solution.
Hi @Anonymous ,
Check the measures as below.
Measure =
var max_date = CALCULATE(MAX('Table'[date]),ALLEXCEPT('Table','Table'[plantid]))
return
IF(SELECTEDVALUE('Table'[date])=max_date,SUM('Table'[value]),BLANK())
Measure 2 = SUMX('Table',[Measure])
Best Regards,
Jay
Hi @Anonymous ,
Check the measures as below.
Measure =
var max_date = CALCULATE(MAX('Table'[date]),ALLEXCEPT('Table','Table'[plantid]))
return
IF(SELECTEDVALUE('Table'[date])=max_date,SUM('Table'[value]),BLANK())
Measure 2 = SUMX('Table',[Measure])
Best Regards,
Jay
Here is a measure expression that should work.
RecentValue =
VAR vLastValue =
SUMX (
VALUES ( T1[PlantID] ),
CALCULATE (
LASTNONBLANKVALUE (
T1[Date],
AVERAGE ( T1[Value] )
)
)
)
RETURN
IF (
OR (
NOT (
HASONEVALUE ( T1[PlantID] )
),
MAX ( T1[Date] )
= CALCULATE (
MAX ( T1[Date] ),
ALLSELECTED ( T1[Date] )
)
),
vLastValue
)
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Hi there, thanks for your support.
Unfortunately, it does not the trick.
It shows me 15 on all rows where plantid is 456. I only want to see it on the row where the modification date = max date.