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

Not sure what exactly you're asking for but in the image above I need to be able to select only the most recent interaction each application has, in the example above I only want to be  counting record 3 for application A, and record 2 for application B. I'm currently using:

CALCULATE(MIN(Table[LatestRecord]),ALLEXCEPT(Table,Table[AppID],Table[Rel Date]))
This works when there are no filters on relative date, however when I use a slicer to change the available relatives dates it stops working, and shows each record as the value. If I take out the Table[Rel Date] from the function, it always shows the final record regardless of the relative date.
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