Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. 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.
User | Count |
---|---|
84 | |
77 | |
76 | |
43 | |
36 |
User | Count |
---|---|
109 | |
56 | |
52 | |
48 | |
43 |