Forum Discussion

sfernamer's avatar
sfernamer
Icon for Helper III rankHelper III
3 years ago
Solved

Calculate filter not working when adding dimension

Good morning,   Firstly, wishing you a merry x-mas! 🙂    I'm working on a dashboard that it has to show different measures based on different subsets. There's a database with rows representing a...
CALCULATE
Filter
MAX date
  • FreemanZ's avatar
    FreemanZ
    3 years ago

    hi   sfernamer 

    try like:
     
    Pts/G_Last = 
    VAR _date = CALCULATE( MAX(database[Date]), ALL(database))
    RETURN CALCULATE( [Pts/G], database[Date] = _date )

     

FreemanZ's avatar
FreemanZ
Icon for Super User rankSuper User
3 years ago

hi   sfernamer 

try like:
 
Pts/G_Last = 
VAR _date = CALCULATE( MAX(database[Date]), ALL(database))
RETURN CALCULATE( [Pts/G], database[Date] = _date )

 

sfernamer's avatar
sfernamer
Icon for Helper III rankHelper III
3 years ago

Hi FreemanZ ,

 

Thank you for your answer. I already checked your advice and worked for me. I did some tests and all worked so thank you so much for your info.

 

I guessed that I can't use the measure as a filter so it's better to create the variable and then use it as a filter in calculate.

 

Merry X-Mas! 🙂