Forum Discussion
Need help for visual
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.
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.
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.
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.
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.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.