Forum Discussion

HanhLe's avatar
HanhLe
Frequent Visitor
1 year ago

RANKING VALUE

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  
Anonymous's avatar
Anonymous
Not applicable
1 year ago

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.

HanhLe's avatar
HanhLe
Frequent Visitor
1 year ago

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

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    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!

    • HanhLe's avatar
      HanhLe
      Frequent Visitor
      1 year ago

      Hi Anonymous 

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