Forum Discussion

kokoro_1202's avatar
kokoro_1202
Helper I
5 years ago
Solved

Need help for visual

hello everyone

I am a newbie & got stuck while trying to get the visual.

How can i show the total number of product sold for each shop?
Somehow the data for the main street & HQ are the same?

 

Can anyone help me. Thank you.

https://gofile.io/d/NX33Oh

Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    5 years ago

    Hi, kokoro_1202 

    Thank you for your feedback.

     

    I thought product sold count = count of transaction ID -> Please correct me if I am wrong.

     

    And, I counted distinct value of transaction ID -> For instance, in January, there is one transaction ID (TransactionID 48925007) shown twicein W67 mainstreet and 45TY mainstreet. I counted this as one value = distinct count.

    If you want to count separately, instead of using "distinctcount", I can use "count".

     

    Thank you very much.

     

    Hi, My name is Jihwan Kim.

    If this post helps, then please consider accept it as the solution to help other members find it faster.

     

7 Replies

    • kokoro_1202's avatar
      kokoro_1202
      Helper I
      5 years ago

      Anonymous 

      hihi, for Jan, total transaction is 20, but the number of product sold for HQ & high street are wrong?

      For example: Jan should HQ=7 & Main street = 13.

      Did I missed out anything?

       

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super User
    5 years ago

    Hi, kokoro_1202 

    I am not sure if you are looking for the below picture-type result.

    I was wondering why shopID 138 was in both HQ and Mainstreet, but I assumed there might be the reason.

    If you are looking for something like below picture, the table has to be transformed. I transformed the table, and please check the link down below.

     

     

    https://www.dropbox.com/s/04cqeonbmyu41fs/Sales%20%281%29.pbix?dl=0 

     

    Hi, My name is Jihwan Kim.

    If this post helps, then please consider accept it as the solution to help other members find it faster.

    • kokoro_1202's avatar
      kokoro_1202
      Helper I
      5 years ago

      Jihwan_Kim 

      The orginal source file with shop ID column contain a mixture of Shopname & product name. Using excel, i create column HQ & Main Street with their respective product ID., then import to power bi.

      So i am trying to show the total no. of product sold by HQ & Main Street. (product ID is not required)

      not sure if it is feasible though.

      • Jihwan_Kim's avatar
        Jihwan_Kim
        Super User
        5 years ago

        Hi, kokoro_1202 

        please check the below picture whether it is what you are looking for.

        It is doable by using your table, and I created measures to generate the results.

        I still suggest transforming the table into a more simple structure. But it is still doable by using your format. Please check the amended file link down below.

         

        https://www.dropbox.com/s/zva3wib4a9xgcir/Sales%20%281%29.pbix?dl=0 

         

        Hi, My name is Jihwan Kim.

        If this post helps, then please consider accept it as the solution to help other members find it faster.