topic Re: RANKING VALUE in DAX Commands and Tips

RANKING VALUE

HanhLe — Tue, 15 Oct 2024 09:31:08 GMT

Hi everyone,

I want to make a ranking of product type for each lines follow these description, but I got wrong result, hope to receive your help, thanks

Re: RANKING VALUE

TomasAndersson — Tue, 15 Oct 2024 10:13:11 GMT

Hi,
You need to remove filters on whatever A02, A03 is (products?) so that RANK evaluates over the entire product type and not just over each product. So something like:

Rank = RANKX( ALL(Products[Product]), [Average of PPH], //Or whatever measure you want to rank by , DESC )

Try it out and if it doesn't work you can give some more info on how the data is structured and what measures you have been trying so I can give you more specific advice.

Good luck!

Re: RANKING VALUE

HanhLe — Thu, 17 Oct 2024 02:38:54 GMT

Hi Tomas,

Thanks for your advice, maybe I did not descripe clearly about what result I want to have so let me adjust my BIs visual, I want to rank top PPH line produce each product type, and please consider that 1 line can produce multiple product type.

This analysis can help me know that for each product type, which line produce better. Kindly help to check, thanks a lot

Re: RANKING VALUE

Anonymous — Mon, 21 Oct 2024 06:30:16 GMT

Hi HanhLe , hello TomasAndersson, thank you for the prompt reply!

Check the following measure:

Top PPH = VAR CurrentProductType = SELECTEDVALUE('Table'[Product Type]) VAR CurrentLine = SELECTEDVALUE('Table'[Line]) RETURN RANKX( FILTER( ALL('Table'), 'Table'[Product Type] = CurrentProductType ), CALCULATE(SUM('Table'[PPH])), , ASC, DENSE )

Result:

Best regards,

Joyce

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: RANKING VALUE

HanhLe — Tue, 22 Oct 2024 08:07:18 GMT

Hi,

Could you help to check my data, seem it does not work

Re: RANKING VALUE

HanhLe — Tue, 22 Oct 2024 08:12:03 GMT

Hi,

Could you help to check my data, seem the result is not same as yours data's demonstration, thanks

Re: RANKING VALUE

HanhLe — Tue, 22 Oct 2024 08:27:42 GMT

Could you quick check my data, I follow your instruction but seem it returns wrong result

Re: RANKING VALUE

Anonymous — Thu, 24 Oct 2024 07:51:21 GMT

Hi HanhLe ，

Thank you for your feedback.

Can you please help identify if you have duplicate product lines for your product type?

If so, we recommend that you summarise the table first and then rankx according to the summary table:

Table 2 = SUMMARIZE('Table', 'Table'[Line], 'Table'[Product Type], "PPH",(SUM('Table'[PPH])))

If the issue persists, please upload your sample pbix file for further troubleshooting.

In addition, do not include sensitive information or anything not related to the issue or question.

Best regards,

Joyce

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: RANKING VALUE

HanhLe — Fri, 25 Oct 2024 06:16:17 GMT

Hi Anonymous

Thanks a lots for your checking

Yes I think the issue is from duplicate value by another column is [Date].

I would prefer not to summarize the table coz I still need [Date] filter for analysis

Since I cannot attached pbix file here so please access this link for data with more clear for you.

https://drive.google.com/file/d/12c6i-rNCfTnLAdIkdl7gaDOQ1zCerZ2b/view?usp=sharing

Re: RANKING VALUE

Anonymous — Mon, 28 Oct 2024 02:40:00 GMT

Hi HanhLe ,

I’m unable to open the link file you shared.

Could you please check the link or provide the information without any sensitive information in a different format?

Thank you for your understanding!

Re: RANKING VALUE

HanhLe — Fri, 01 Nov 2024 02:57:07 GMT

Hi Anonymous

Since I cannot attach file here so please check the link again. I already opened link access