Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Drill down and strange filter behaviour

Hello PBI community,   I'm facing a strange behaviour with my PBI report, and I don't really understand why this happens. I simplified as much as I can the model to be as clear as possible.   Fi...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    Anonymous , This seems correct, Try with this one change. As I doubt row context

     

    Measure2 = var datemin = MINX(allselected('Table A'),'Table A'[DATE])
    var datemax = MAXX(allselected('Table A'),'Table A'[DATE])

    RETURN CALCULATE((DISTINCTCOUNT('Table A'[Player]));
    'Table A'[Type] = "X";'Table A'[DATE] >= DATE(YEAR(datemin)-1 ; MONTH(datemin); DAY(datemin));
    'Table A'[DATE] <= DATE(YEAR(datemax)-1 ; MONTH(datemax); DAY(datemax)))

     

    if it gives an error , just return _min or _max and check what you get. Do you get any blank

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

Anonymous , This seems correct, Try with this one change. As I doubt row context

 

Measure2 = var datemin = MINX(allselected('Table A'),'Table A'[DATE])
var datemax = MAXX(allselected('Table A'),'Table A'[DATE])

RETURN CALCULATE((DISTINCTCOUNT('Table A'[Player]));
'Table A'[Type] = "X";'Table A'[DATE] >= DATE(YEAR(datemin)-1 ; MONTH(datemin); DAY(datemin));
'Table A'[DATE] <= DATE(YEAR(datemax)-1 ; MONTH(datemax); DAY(datemax)))

 

if it gives an error , just return _min or _max and check what you get. Do you get any blank

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thank you Amitchandak, it did work !!

I suspected a contest thing, I tried ALL functions, but ALLSELECTED is all I needed !

Fast and accurate, thank you again 🙂