Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

How to use RANKX with TOTALYTD

Hi Everyone, 

 

I'm stucked here with a problem. I have a table with a lot of columns that im try to filter basing on a difference between two values. These difference was calculated based on two measures that uses TOTALYTD and when i use RANKX, i get some crazy ranking. Could anyone help me out?

 

Thanks in advance.

 

rankTeste = RANKX(ALLSELECTED('Objetivo Faturamento'[Descrição]);CALCULATE(IF(
    ISFILTERED('Data'[Date]);
    ERROR("Medidas rápidas de inteligência de tempo somente podem ser agrupadas ou filtradas pela hierarquia de data fornecida pelo Power BI ou pela coluna de data primária.");
    TOTALYTD(SUM('Objetivo Faturamento'[Orçado]); 'Data'[Date].[Date])
);'Objetivo Faturamento'[Metricas] = "Faturamento"))
 
 
As can be seen, the number 5 is bigger than the number 6,7,8.
 
No Replies