Rankx change behaviour when I add line in a matrix

[vbourbeau]

Hi,

I create a measure for ranking client. I use it on a matrix where the line are the client and the part number.

So if we drill down the client we see all part bought.

I create a Rankx DAX command to rank my client. The rank work but when I add my part number as a line the rank only give 1.

example.pbix

[v-danhe-msft]

Hi @vbourbeau ,

Based on my research, it is due to the filter in different conditions, you could refer to below link:

https://dataninjago.com/2017/12/11/dax-ranking-with-hierarchy-drill-down/

Regards,

Daniel He

[vbourbeau]

Thank you your post help me but it's still something wrong.

I need to put a filter to eliminate the client with empty amount. So I add a filter if amount empty.

If I put this filter the isfiltered value change to True?

Example.pbix