Rank based on two individual measures

[joshua1990]

Hi all!

I have a dimension table that contains all articles and then I have a transactional table. This transactional tables contains two value columns. I use a simple SUM function to get this numbers (Value 1 and Value 2) for a matrix visual:

Article	Value 1	Value 2	Rank Value	Rank
1	50%	5%	5,5	3
2	80%	10%	10,8	2
3	60%	11%	11,6	1

Now, I would like to build a ranking based on this two measures.

For that, I build a third measure with this logic:

([Value 2] * 100) + [Value 1]

To get the ranking here I created this function:

RANKX (ALLSELECTED(Article[Article]), [Ranking Value])

But this results always in a 1. 

The result that I need you can find in the last column.

Why is this function showing always 1?

[ValtteriN · Accepted solution]

Hi,

In what context did your measure return 1? I tried to re-create the issue, but the values I gor are like your desired values:

[joshua1990]

@ValtteriN : Thanks a lot for your support. Do you have a datamodel with 2 tables or is it just one?

[ValtteriN]

@joshua1990  My test data is just one table