LAST NON BLANK

[bhelou]

Dear , 

I have this measure ( below ) , calculation for it in the rows inside the table is correct , but in the summation it is refereing to the last non blank value that i have , it is not summing it up , kindly if you can help with modifying the measure , thanks 

Cost =

VAR COST =

    ROUND(CALCULATE (

        LASTNONBLANK(

            XXAWPT_FA_DEPRN_SUMMARY[ADJUSTED_COST],

            XXAWPT_FA_DEPRN_SUMMARY[ADJUSTED_COST]

        ),

        XXAWPT_FA_DEPRN_SUMMARY[DEPRN_SOURCE_CODE] = "DEPRN",

        FILTER (

            XXAWPT_FA_DEPRN_SUMMARY,

            XXAWPT_FA_DEPRN_SUMMARY[DEPRN_RUN_DATE]

                = MAX ( XXAWPT_FA_DEPRN_SUMMARY[DEPRN_RUN_DATE] ))),0)

RETURN

    ROUND(CALCULATE (

        Cost,

        FILTER (

            ALL ( '*Dates' ),

            '*Dates'[Date]

                <= MAX ( '*Dates'[Date] )

        )

    ),0)

Thank you 

[bhelou]

Thank you very much it worked , 1 M kudos , thank you @amitchandak 

[v-stephen-msft]

Hi @bhelou ,

This is a common issue.

I tried to reproduce your issue. The total  should be 7 not 5.

You can create a new measure using ISINSCOPE to solve.

Measure = IF(ISINSCOPE('Table'[Month]),[Cost],SUMX('Table',[Cost]))

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak · Accepted solution]

@bhelou , What are you trying to get here?

Check how sum up latest values

Latest

https://amitchandak.medium.com/power-bi-get-the-sum-of-the-last-latest-value-of-a-category-f1c839ee8...