Forum Discussion
RANKX Measure
- Anonymous8 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.
Hi ccakjcrx. Thanks for your reply.
I've tried as you described but it's not working for me. The IF condition could be or not, never mind about that. The problem is with the RANKX.
Here is my model:
This is the Sales measure:
Ventas IMS =
SWITCH(
VALUES('Selector Medida'[Medida]);
"USD";
'Medidas VentasIMS'[Ventas IMS MUSD];
"ML";
'Medidas VentasIMS'[Ventas IMS ML];
"UN";
'Medidas VentasIMS'[Ventas IMS MUN]
)And "USD" as example:
Ventas IMS MUSD =
SWITCH(
VALUES(
'Selector Período'[Período]
);
"YTD";
CALCULATE(
SUM(
'Ventas IMS'[ImporteVendidoUSD]
);
DATESYTD(
'Período IMS'[Fecha]
)
);
"MTH";
SUM(
'Ventas IMS'[ImporteVendidoUSD]
);
"MAT";
CALCULATE(
SUM(
'Ventas IMS'[ImporteVendidoUSD]
);
DATESINPERIOD(
'Período IMS'[Fecha];
LASTDATE(
'Período IMS'[Fecha]
);
-1;
YEAR
)
)
)And the RANKX:
Ranking Grupos =
RANKX(
ALLSELECTED('GruposIMS');
ROUND('Medidas VentasIMS'[Ventas IMS];0)
)I've deleted the IF condition.
I'm still getting 1 position of rank for all options of "Grupo".
Any other advice?
Anonymous
Please try this
Ranking Grupos =
RANKX (
ALLSELECTED ( 'GruposIMS' ),
CALCULATE ( VALUES ( 'Medidas VentasIMS'[Ventas IMS] ) )
)
- Anonymous8 years agoNot applicable
Hi Zubair_Muhammad.
VALUES does not work with measures. It only works when calling a column of a table.
- Zubair_Muhammad8 years agoCommunity Champion
Anonymous
My aplogies. I thought
'Medidas VentasIMS'[Ventas IMS]
is a calculated column