Forum Discussion

aqavi10's avatar
aqavi10
Icon for Advocate I rankAdvocate I
6 years ago
Solved

Top value in a category based on 2 columns

Hi everyone,     Can someone please help me accomplish this task below? I need to display the store with the highest sales in a 'Card' visual. This needs to be categorized based on the 'State' and ...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    6 years ago

    Hi,

    You may download my PBI file from here.

    Hope this helps.

aqavi10's avatar
aqavi10
Icon for Advocate I rankAdvocate I
6 years ago

Hi Ashish, 

 

  This is regarding your solution yesterday.    It doesn't show the right store as per the highest sales. I've included more data in this sample , however it doesn't reflect the right store.  

Thank you

 

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
6 years ago

Hi,

What is the problem?  My answer is correct.  See the screenshot below:

  • aqavi10's avatar
    aqavi10
    Icon for Advocate I rankAdvocate I
    6 years ago

    Hi Ashish,

     

      The answer is absolutely correct for total dollar sales when checked per year. Apologies in conveying the 2nd question aptly! However, if I wanted to show the highest earning store by week on the card and not the sum of sales for the whole year for any store , how would I be able to do it?

     

    Example:

    In the dataset shared, highest earning store by week for Tasmania is Store Devonport in 2019 and Store Northgate in 2018.  

     

    Thanks again for the help! 

    Cheers :)

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Icon for Super User rankSuper User
      6 years ago

      Hi,

      I am still confused.  You can create a slicer for Week as well and select any one week.

      • aqavi10's avatar
        aqavi10
        Icon for Advocate I rankAdvocate I
        6 years ago

        Hi Ashish,

         

          Apologies for the confusion. I meant, if we wanted the visual card to display the store which has earned highest in a particular week in the year selected. Basically, the ideal output would be the card displaying the store name/week number/amount(highest selling week) without the need to slice by week number. As of now, with the current solution, I'm able to display the amount rightly on a card for the highest selling store (in a week) but not the store .