Forum Discussion

jimmyfromus's avatar
jimmyfromus
Helper III
5 years ago
Solved

Min value based on year column

Hi,    I've 2 columns, one with year and one with an integer value.    Year rank 2017 35 2018 36   I'm simply trying to create a measure for this to calculate the minimum value t...
Need Help
  • jimmyfromus's avatar
    jimmyfromus
    5 years ago

    parry2k I used this DAX which seems to work for me. 

     

    Measure = CALCULATE(
    MIN(Comparison[rank]),
    FILTER(ALLSELECTED(Comparison),
    (Comparison[Year] = (MIN( Comparison[Year] )))
    )
    )
  • jimmyfromus's avatar
    jimmyfromus
    Helper III
    5 years ago

    parry2k, Ok, so I've a table with 2 columns, year and rank(both are whole number columns). I've a slicer using the year and then a card visual using the min value of the rank. When no year is selected in the slicer, the year value is picked up as 2017 in the card visual and the rank (min value) is shown as 14 in the card visual. I would however like that the year value is 2017 but the rank value is shown as 15. What measure would I need to use to do this? 

     

  • jimmyfromus's avatar
    jimmyfromus
    Helper III
    5 years ago

    parry2k I used this DAX which seems to work for me. 

     

    Measure = CALCULATE(
    MIN(Comparison[rank]),
    FILTER(ALLSELECTED(Comparison),
    (Comparison[Year] = (MIN( Comparison[Year] )))
    )
    )