Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Slicer Selection

Dears, I need help for this issue, I have a table containing year, month, rank for each player, the rank represent in a card in the power bi Issue: if the user selects specific year and no month sel...
General Comment
Need Help
Tips and Tricks
  • v-lili6-msft's avatar
    v-lili6-msft
    6 years ago

    hi  Anonymous 

    You just use ISFILTERED Function to create a measure as below:

    Measure =
IF(ISFILTERED('Table'[month]),
CALCULATE(SUM('Table'[rank])),
CALCULATE(SUM('Table'[rank]),FILTER('Table','Table'[month]=MAX('Table'[month]))) )

     

    and here is sample pbix file, please try it.

     

    Regards,

    Lin

amitchandak's avatar
amitchandak
Super User
6 years ago

Anonymous , If month year is selected, than maxx(Value(Table[Month]),[Rank]) should give you max

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    amitchandak what i need here that the year only selected , after that the slicer of the month will fill with the months available for selected year , if the user did not select a specific month then i git the max month in the slicer and get the rank for this month (max month)