Forum Discussion
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...
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
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