Forum Discussion

shakirkhanani's avatar
shakirkhanani
Icon for Helper I rankHelper 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's avatar
    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's avatar
    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] ) )
)

     

     

shakirkhanani's avatar
shakirkhanani
Icon for Helper I rankHelper I
8 years ago

Brilliant! How can I further expand to show the Total Amount of the Measured Receipt No. 

Zubair_Muhammad's avatar
Zubair_Muhammad
Icon for Community Champion rankCommunity Champion
8 years ago

Hi shakirkhanani

 

Its there in the variable of the above MEASURE

 

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