Forum Discussion

SBethell's avatar
SBethell
Regular Visitor
3 years ago

Dynamically Calculating minimum value

I'm trying to visualise the movement of applications thorugh our system, using a dataset that produces a record for every interaction that the application has had with our system, but I only want to ...
SBethell's avatar
SBethell
Regular Visitor
3 years ago

Image 1 is when there is no filter on date, LastSSCandInteraction is the measure Ihad at the start, measure is the the DAX you suggested. Image 2 is when I have a filter on relative date which does not affect any of the interactions on the application

tamerj1's avatar
tamerj1
Community Champion
3 years ago

SBethell 
Not sure if I fully understand, However, please try

=
CALCULATE (
    MIN ( Table[LatestRecord] ),
    ALL ( 'Table' ),
    VALUES ( 'Table'[AppID] )
)

or

=
CALCULATE ( 
    MIN ( Table[LatestRecord] ), 
    ALLEXCEPT ( 'Table', 'Table'[AppID] ) 
)
  • SBethell's avatar
    SBethell
    Regular Visitor
    3 years ago

    Unfortunately still no dice, but I realised I didn't share the formula I've worked out in excel. MINIFS($B$2:$B$21,$C$2:$C$21,">="&$I$2,$C$2:$C$21,"<="&$J$2,$A$2:$A$21,A2)