Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi!
I do not finish understandig RANKX beacuse Im using it but I cant make it rank the things well. In this scenario I have several filters and I need every filter I aplied the rank so... ranks the selected thing. I know I got help before about RANKX but all their previous solutions didnt get success.
Here is my pbix file https://1drv.ms/u/s!AtTnrgPUQzQCnAUc2MYHfnad2lPl , sorry but is some huge.
Thanks for your help.
Solved! Go to Solution.
Hi, try with:
Measure = IF ( [Parte 1 Gobierno Corporativo Diferencia] <> BLANK (), RANKX ( ALLSELECTED ( 'Tabla Cruce'[NIT] ), CALCULATE ( [Parte 1 Gobierno Corporativo Diferencia], ALLEXCEPT ( 'Tabla Cruce'; 'Tabla Cruce'[NIT] ), ALLSELECTED ( 'Sectores CIIU Codigos'[Sector] ) ), , DESC, DENSE ) )
Regards
Victor
Lima - Peru
Hi, try with:
Measure = IF ( [Parte 1 Gobierno Corporativo Diferencia] <> BLANK (), RANKX ( ALLSELECTED ( 'Tabla Cruce'[NIT] ), CALCULATE ( [Parte 1 Gobierno Corporativo Diferencia], ALLEXCEPT ( 'Tabla Cruce'; 'Tabla Cruce'[NIT] ), ALLSELECTED ( 'Sectores CIIU Codigos'[Sector] ) ), , DESC, DENSE ) )
Regards
Victor
Lima - Peru
Hi @Vvelarde
Thabks for your response but your formula does not work, the result is the same I posted.
It would be better to simplify your model and show us the expected result with dummy data.