Forum Discussion

adii's avatar
adii
Helper I
3 years ago
Solved

Why I received wrong filter data

Hello , I got the problem with filter data such as above on screen.

 

I would like receive simple result. I wants show last date from table. 

when I use measure with specific day (Date(year,month,day) everything works fine , but I use lastdate or max formula . I get wrong results 

 

general I in my case I would like receive table with sum (TEST measure ) in latest day in table

 

sorry for quality of images  

Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi adii ,

    You can update the formula of your measure [TEST] as below, then you can get the expected result...

    TEST =
VAR last_day =
    MAXX ( ALL ( 'LNG' ), 'LNG'[Date_ID] )
RETURN
    CALCULATE (
        SUMX ( 'LNG', [Cap [m3]] tys] * 1000 ),
        FILTER ( 'LNG', 'LNG'[Date_ID] = last_day )
    )

    or

    TEST =
VAR last_day =
    CALCULATE ( LASTDATE ( 'LNG'[Date] ), ALL ( 'LNG' ) )
RETURN
    CALCULATE (
        SUMX ( 'LNG', [Cap [m3]] tys] * 1000 ),
        FILTER ( 'LNG', 'LNG'[Date_ID] = last_day )
    )

    Best Regards

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi adii ,

    You can update the formula of your measure [TEST] as below, then you can get the expected result...

    TEST =
VAR last_day =
    MAXX ( ALL ( 'LNG' ), 'LNG'[Date_ID] )
RETURN
    CALCULATE (
        SUMX ( 'LNG', [Cap [m3]] tys] * 1000 ),
        FILTER ( 'LNG', 'LNG'[Date_ID] = last_day )
    )

    or

    TEST =
VAR last_day =
    CALCULATE ( LASTDATE ( 'LNG'[Date] ), ALL ( 'LNG' ) )
RETURN
    CALCULATE (
        SUMX ( 'LNG', [Cap [m3]] tys] * 1000 ),
        FILTER ( 'LNG', 'LNG'[Date_ID] = last_day )
    )

    Best Regards