Forum Discussion

hidenseek9's avatar
hidenseek9
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...
Need Help
  • Ashish_Mathur's avatar
    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.

     

hidenseek9's avatar
hidenseek9
Post Patron
8 years ago

Anonymous

 

Thank you for your reply.

I am having a trouble with the DAX formula you provided on AVERAGE.

 

when I type VAR as a DAX function, below four comes up.

VAR.P

VAR.S

VARX.P

VARX.S

which one do I use to run the DAX formula you provided?

 

And what would the new formula look like?

 

Many thanks,

 

H

 

 

 

 

hidenseek9's avatar
hidenseek9
Post Patron
8 years ago

Anonymous

 

I am having a trouble with your solution.

Which VAR DAX should I select?

 

Or any other way to solve the issue?

 

Many thanks,

 

H