How to use RANKX with TOTALYTD

[Anonymous]

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.