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

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.

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

Hi shakirkhanani

 

Don't worry ......With time you will get to grip with Power BI.....

 

Here are some tips :smileyhappy:

 

1) Start solving the problems in this forum

2) Read the books...Following are some good books