Forum Discussion

rafterse's avatar
rafterse
Icon for Helper I rankHelper I
2 years ago
Solved

Count of Roles per use based on two slider dates

      what i want to do is create a mesure for the "countDisRoles" for "Min Date slicer" measure and another measure for the "Max Date slicer"    and them be able to use these two new meas...
Need Help
  • amitchandak's avatar
    amitchandak
    2 years ago

    rafterse , Try measures like

     

    new measure =
    var _max = maxx(allselected(Date),Date[Rank])
    return
    calculate( DISTINCTCOUNT(Table[Column]), filter('Date', 'Date'[Date] =_max))


    new measure 1=
    var _min = Minx(allselected(Date),Date[Rank])
    return
    calculate( DISTINCTCOUNT(Table[Column]), filter('Date', 'Date'[Date] =_min))

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
2 years ago

rafterse , Try measures like

 

new measure =
var _max = maxx(allselected(Date),Date[Rank])
return
calculate( DISTINCTCOUNT(Table[Column]), filter('Date', 'Date'[Date] =_max))


new measure 1=
var _min = Minx(allselected(Date),Date[Rank])
return
calculate( DISTINCTCOUNT(Table[Column]), filter('Date', 'Date'[Date] =_min))