Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not 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"))
 
Capturar.PNG
 
As can be seen, the number 5 is bigger than the number 6,7,8.
 
0 REPLIES 0

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors