Need help for visual

[kokoro_1202]

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

[Jihwan_Kim]

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]

@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]

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.

[kokoro_1202]

@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 · Accepted solution]

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.

[Anonymous]

HI @kokoro_1202 

PFA the file below

[kokoro_1202]

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