Forum Discussion

s15's avatar
s15
Icon for Helper III rankHelper III
9 years ago
Solved

DAX or Measure to show top largest values

Hi all,   I have a list of products and sales revenues. I want to list only 10 products which have the highest sales value. What kind of function can I use in this case?   Saying the product colu...
Need Help
  • vanessafvg's avatar
    vanessafvg
    9 years ago

    s15

     

    when you say its wrong ,  is it because the total is wrong?  are you filtering on anything else?    or is because its not the top, you should change your asc to desc if you want the top

     

    in terms of the measure you should be able to, for readbility though i would probably change the measure to this

     

     

    Top 2 =
    VAR totalSales =
        SUM ( financials[ Sales] )
    RETURN
        CALCULATE (
            totalSales,
            FILTER (
                VALUES ( financials[Product] ),
                IF (
                    RANKX ( ALL ( financials[Product] ), [Total Sales],, desc) <= 2,
                    [Total Sales],
                    BLANK ()
                )
            )
        )

vanessafvg's avatar
vanessafvg
Icon for Community Champion rankCommunity Champion
9 years ago

s15 remove the [ brackets i think you using a variable

s15's avatar
s15
Icon for Helper III rankHelper III
9 years ago

Thank you vanessafvg

 

I make it a variable but now it seems not to be working. I think DESC with 2 is OK but somehow it doesn't filter two products.

 

  • vanessafvg's avatar
    vanessafvg
    Icon for Community Champion rankCommunity Champion
    9 years ago

    s15 can you bring the ranking back as well?  ive picked up one issue and that is the

     

      CALCULATE(SUM ( Sales[TotalCost] ))

     

    need to have a calculate in front of it as all the ranking one will be 1.

     

    i think the calculation is incorrect, need to check it out properly on video, will look at later