Forum Discussion
Anonymous
7 years agoNot applicable
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