Hi,
In MS DOCS on RANKX it has the following;
=
But on trying this myself I could not get this to work;
But if I Used the Measure TotalUnits ; SUM(Table1[Unit]),
Then it did, likewise if I wrapped the SUM in Calculate ;
It worked, my question regards why the initial MS example does not need calculate?
Richard
In MS DOCS on RANKX it has the following;
=
Excel Formula:
RANKX(ALL(Products), SUMX(RELATEDTABLE(InternetSales), [SalesAmount]))
But on trying this myself I could not get this to work;
Excel Formula:
RankItemC:=RANKX( ALL(Table1[Item]), SUM(Table1[Unit]), ,DESC ,Dense )
But if I Used the Measure TotalUnits ; SUM(Table1[Unit]),
Excel Formula:
RankItemA:=RANKX( ALL(Table1[Item]),[TotalUnits] ,,DESC,Dense)
Then it did, likewise if I wrapped the SUM in Calculate ;
Excel Formula:
RANKX( ALL(Table1[Item]), CALCULATE( SUM(Table1[Unit])),,DESC ,Dense )
It worked, my question regards why the initial MS example does not need calculate?
Richard