Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

RANKX Measure

Hi to everyone!   I'm stuck with a RANKX measure that ranks always in 1 position. Hope somebody can help me with this.   As you can see, I have a matrix opened by "Grupo". I need to rank ea...
General Comment
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    8 years ago

    Hi everyone!

     

    Happy to say that is know working, and ashamed after discovering the problem.

     

    The "Grupo" shown in the matrix, is from the facts table, not from the table "GruposIMS". I just changed the dimension of the matrix and the RANKX measure started to show real values.

     

    Thanks for the help.

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

Hi Anonymous,

 

There could be something wrong with your model. The table GropusIMS has no relationship with the table Selector Medida. The second parameter of RANKX could always return the same value. So the result of RANKX could be the same. Can you share the pbix file? You can delete all the confidential parts first.

 

Best Regards,

Dale

 

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi v-jiascu-msft.

 

I've tried introducing all the calculations that involve "Selector Medida" to the RANKX measure without success,

 

Anyway, the kind of logic that I'm using for this RANKX measure that is not working, is being used in a other measure and it's working fine:

Ranking MegaPharma = 
IF(
	'Medidas VentasIMS'[Ventas IMS] <> 0;
	CALCULATE(
		RANKX(
			ALL('GruposIMS'[Grupo]);
			ROUND('Medidas VentasIMS'[Ventas IMS];0)
		);
		FILTER(
			ALL('GruposIMS'[Grupo]);
			'GruposIMS'[Grupo] = "** MEGA PHARMA **"
		)
	)
)

This measure is used here, in the 2 left tables:

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi everyone!

     

    Happy to say that is know working, and ashamed after discovering the problem.

     

    The "Grupo" shown in the matrix, is from the facts table, not from the table "GruposIMS". I just changed the dimension of the matrix and the RANKX measure started to show real values.

     

    Thanks for the help.