Forum Discussion

Post Patron

8 years ago

Solved

Calculating average price using distict count??

Hello Power BI Community I am having a difficulty calculating average price of all of our products per store per month. Please find below as the data. Dummy Data What I want to do is simple...

Ashish_Mathur
8 years ago
Hi hidenseek9,

Try these formulas

Count=DISTINCTCOUNT(Data[Store])
Contribution (%)=[Count]/CALCULATE([Count],ALL(Data[Brand]),ALL(Data[Product]))

Hope this helps.

Post Patron

8 years ago

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

Super User

8 years ago

Try these formulas

Count=DISTINCTCOUNT(Data[Store])

Contribution (%)=[Count]/CALCULATE([Count],ALL(Data[Brand]),ALL(Data[Product]))

Hope this helps.