Forum Discussion

Helper I

8 years ago

Solved

Highest Basket (Receipt) Value

Hello, I need help in trying to find the highest / Max "Receipt No." baesd on the "Amount" as per the below Data Table: Receipt No. Goods Code Time Price Qty Amount 201803230001 ...

Need Help

Zubair_Muhammad

8 years ago

Hi shakirkhanani

Try this MEASURE

Measure =
VAR MaxAmount =
    MAXX (
        ALLSELECTED ( Table1[Receipt No.] ),
        CALCULATE ( SUM ( Table1[Amount] ) )
    )
RETURN
    CALCULATE (
        FIRSTNONBLANK ( Table1[Receipt No.], 1 ),
        FILTER (
            ALLSELECTED ( Table1[Receipt No.] ),
            CALCULATE ( SUM ( Table1[Amount] ) ) = MaxAmount
        )
    )

Zubair_Muhammad
8 years ago
Hi shakirkhanani

Its there in the variable of the above MEASURE

MaxAmount = MAXX ( ALLSELECTED ( Table1[Receipt No.] ), CALCULATE ( SUM ( Table1[Amount] ) ) )