Forum Discussion
Calculating average price using distict count??
Hi hidenseek9,
Try these formulas
Count=DISTINCTCOUNT(Data[Store])
Contribution (%)=[Count]/CALCULATE([Count],ALL(Data[Brand]),ALL(Data[Product]))
Hope this helps.
What I would like to know is below on any given month.
- A total number of stores checked. (i.e. Brand A: 200 stores, Brand B: 300 stores,...All Brand 1000 stores)
- A total number of stores that each product is sold. (i.e. Brand A Product Name 1: 50 stores, Brand A Product Name 2: 100 stores, etc.)
- Distribution of each product in percentage. (This would be 2 / 1 (A total number of stores checked for all brands)
Many thanks,
H
Hi,
When i try to build a Pivot Table, i get the same number of stored checked for all brands. There is something wrong with the dummy data that you have shared. Share a smaller dataset and with respect to that smaller dataset, share the expected result (show actual numbers that you are expecting there).
Here is a simplified version of the sample data.
I have also attached the answers to the questions in the file already.
Basically, I would like to calculate the following in PowerBI
- Air Jordan Distribution (Brand)
- Air Jordan 1 Distribution
- Air Jordan 2 Distribution
- Carmelo Distribution (Brand)
- Carmelo 1 Distribution
- Carmelo 2 Distribution
Many thanks,
H
Hi hidenseek9,
Try these formulas
Count=DISTINCTCOUNT(Data[Store])
Contribution (%)=[Count]/CALCULATE([Count],ALL(Data[Brand]),ALL(Data[Product]))
Hope this helps.