Forum Discussion
Roland74
Helper I
Helper IHow to get the highest value on the same date
Hi, im struggling with this case. I've got this table: (For the month June everything is the same, except the 'ResultID') For a selected month i need the highest ResultID, i.e. for June i w...
After some trial-and-error i found the solution, which was quite simple.
MaxID_Calc2 = CALCULATE(MAX(factProjectPreclosureResult[ProjectPreclosureResultID]),ALL(factProjectPreclosureResult[ProjectPreclosureResultID]),ALL(factProjectPreclosureResult[PostingDateID]))
bhanu_gautam
Super User
Super UserRoland74 , Create a measure to get the highest ResultID for the selected month:
DAX
MaxResultID =
CALCULATE(
MAX(Table[ResultID]),
ALLEXCEPT(Table, Table[Month])
)
Create a measure to check if the ResultID is the highest for the selected month:
DAX
IsMaxResultID =
IF(
Table[ResultID] = [MaxResultID],
1,
0
)
Add the IsMaxResultID measure to the visual level filters.
Set the filter to show only rows where IsMaxResultID is 1.
Roland74Hi Bhanu,
Thanx for your reaction, but that doesn't seem to do the trick.
Still get the same result