Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Rankx and Sum at grouped level

Hi everyone,   I have a table with those columns: CompanyCode;Year, Currency, product, SalesAmount,client I am trying to Rank the companies by SalesAmount, summed at the level CompanyCode-Year-Cu...
Need Help
Show and Tell
Tips and Tricks
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    Hi Anonymous 

    Create measures

    Measure =
CALCULATE (
    SUM ( Sheet5[SalesAmount] ),
    FILTER (
        ALLSELECTED ( Sheet5 ),
        Sheet5[CompanyCode] = MAX ( Sheet5[CompanyCode] )
            && Sheet5[Year] = MAX ( Sheet5[Year] )
            && Sheet5[Currency] = MAX ( Sheet5[Currency] )
    )
)

Measure 2 = RANKX(ALLSELECTED(Sheet5),[Measure],,DESC,Dense)

     

    Best Regards
    Maggie
    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
lc_finance's avatar
lc_finance
Icon for Solution Sage rankSolution Sage
7 years ago

HI Anonymous ,

 

 

Can you share a sample Power BI file?

You can share it via DropBox, One Drive, Drive or another similar tool.

 

Regards,

 

LC

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi lc_finance 

No sorry i can't. It's from the company i work for nd kind of confidential.

Do you have an idea ?