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? ...
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.

     

kokoro_1202's avatar
kokoro_1202
Helper I
5 years ago

Jihwan_Kim Strange that the count for HQ & Main stree is different from what i counted using countA in excel?
By the way, could you help me understand what does TransactionID does in this formula?

HQ Count =
CALCULATE( DISTINCTCOUNT( 'Sales xlsx'[TransactionID]), 'Sales xlsx'[HQ] <> BLANK())
Thank yo so much for your advice.
Jihwan_Kim's avatar
Jihwan_Kim
Super User
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.