Sum Total of MAXX

[Anonymous]

Hello 

Just working on getting table to show a correct total on a table visual.

The calculation that I am using:

Current Price FOB TEMP =

VAR CurrentDate = TODAY()

VAR AllPreviousRatingsTable =

    FILTER (

        'Market Price',

        'Market Price'[Date] <= CurrentDate

    )

VAR PreviousRatingTable =

    TOPN ( 1, AllPreviousRatingsTable, 'Market Price'[Date], DESC )

VAR PreviousRating =

    MAXX ( PreviousRatingTable, 'Market Price'[Price] )

RETURN

SUMX(

    ADDCOLUMNS(

        SUMMARIZE('Market Price','Market Symbol'[Name]),"LastPrice", PreviousRating),

    [LastPrice])

But the visual is showing an incorrect total (I have filtered for the three specific names):

How can I correct the calculation

[v-stephen-msft]

Hi @Anonymous ,

Please try

Current Price FOB TEMP =
VAR CurrentDate =
    TODAY ()
VAR AllPreviousRatingsTable =
    FILTER ( 'Market Price', 'Market Price'[Date] <= CurrentDate )
VAR PreviousRatingTable =
    TOPN ( 1, AllPreviousRatingsTable, 'Market Price'[Date], DESC )
VAR PreviousRating =
    MAXX ( PreviousRatingTable, 'Market Price'[Price] )
RETURN
    SUMX (
        SUMMARIZE ( 'Market Price', 'Market Symbol'[Name], "LastPrice", PreviousRating ),
        [LastPrice]
    )

Or try

New measure =
SUMX ( 'Market Price', [Current Price FOB TEMP] )

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.           

[Anonymous]

Hello Stephen

I have made the change but seems to be the same outputs:

Seems like everytime I add an extra item to the filter it increases total by $147.50