Question

FIND OUT THE RANK OF A PARTICULAR MONTH IN TERMS OF MAKING SALES.​

Answer 1

Hola! Brainlian!,

To calculate the rank we use the DAX function RANKX (). More documentation can be found on RANKX here. Create a new measure and add the following: Ranking = RANKX (ALLSELECTED ('Clothing Sales' [Category]), CALCULATE (SUM ('Clothing Sales' [Sales])))

$\fbox{ -@Tomboyish27}$