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] ) )
)

     

     

Zubair_Muhammad's avatar
Zubair_Muhammad
Icon for Community Champion rankCommunity Champion
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
        )
    )
  • 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] ) )
)

       

       

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

        Genius, at least to me.  I wasted the half of my Sunday figuring this out.  Thanks again dear Zohaib.  Appreicate if you could share some pointers to me to improve by BI.