How to get the highest value on the same date

Roland74 , 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.

Hi Roland74 

 

Thanks for the reply from bhanu_gautam and Greg_Deckler, please allow me to provide another insight:

 

I added a row of data to the sample data you gave, as follows:

1. Create a calculated column as a slicer table or filter

Slicer = VALUES('Table'[PostingDateID])

 

There is no relationship between the two tables.

 

2. Create a measure as follows

Measure = 
VAR _selected = SELECTEDVALUE('Slicer'[PostingDateID])
VAR _max = CALCULATE(MAX([ProjectPreclosureResultID]), FILTER(ALL('Table'), [PostingDateID] = _selected))
RETURN
IF(_selected = BLANK(), 1, IF(MAX([ProjectPreclosureResultID]) = _max, 1, 0))

 

3. Put the measure into the visual-level filters, set up show items when the value is 1.

 

Output:

 

use slicer

 

or use filter

 

Best Regards,
Yulia Xu

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Roland74 Try:

Measure = 
  VAR __Date = MAX( 'factProjectPreclosureResult'[PostingDateID] )
  VAR __Table = FILTER( ALL( 'factProjectPreclosureResult' ), [PostingDateID] = __Date )
  VAR __Result = MAXX( __Table, [ProjectPreclosureResultID] )
RETURN
  __Result