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 ...
tamerj1's avatar
tamerj1
Community Champion
3 years ago

SBethell 

Please try the following measure 

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

SBethell's avatar
SBethell
Regular Visitor
3 years ago

Just tried it and I'm still getting the same issue where it works for when I have nothing on my slicer but as soon as I adjust the slicer, even if it doesn't impact the application I'm using as a test it shows each record as the minimum again.

  • tamerj1's avatar
    tamerj1
    Community Champion
    3 years ago

    SBethell 
    Would you please provide some screeshots to clarify your point?

    • 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] ) 
)