Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Chart values based on rank

Hello Everyone, I have following dataset: Based on that i want to have 3 charts: 1. Chart #1 is to show items order by sold quantity (pieces) 2. Chart #2 and #3 are to show sales of top 1 s...
DAX
rank
  • Jihwan_Kim's avatar
    Jihwan_Kim
    3 years ago

    Hi,

    I am not sure if I understood your question correctly, but please try the below whether it suits your requirement.

     

    Rank of Sold Items =
CALCULATE (
    MAX ( Sheet2[Item] ),
    FILTER (
        VALUES ( Sheet2[Item] ),
        RANKX ( ALL ( Sheet2[Item] ), CALCULATE ( SUM ( Sheet2[Sold pieces] ) ) ) = 1
    )
)
Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
3 years ago

Hi,

I am not sure if I understood your question correctly, but please try the below whether it suits your requirement.

 

Rank of Sold Items =
CALCULATE (
    MAX ( Sheet2[Item] ),
    FILTER (
        VALUES ( Sheet2[Item] ),
        RANKX ( ALL ( Sheet2[Item] ), CALCULATE ( SUM ( Sheet2[Sold pieces] ) ) ) = 1
    )
)
  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Thank You!

    It seems that you did understood because it works.