Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Calculate the average per category

Hi,   i was searching yesterday within the community for a solution but did not find anything that matches my case. If this was already discussed i would be glad if somebody can piont out the post....
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    Which calculations you have used.

    In case you have used this, hope you created it is a measure, not Column

     

    divide(sum(price),sum(qty))

     

    Please share the formula you created. It should be dynamic. Unless there is join missing.  Or Interactions are off.

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thank you!

 

Using a measure instead of a column was the solution. 

 

Like I said ... the answer was very simple. 

 

I think i need to go back an review the differences between measures and columns.

 

Thanks again for the responses!

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Columns are pre-calculated.  You can see them in the table view. And the measure is calculated run time. means there will impact of data grouping.

 

For Multiple-use, We typically use column A*B and then SUM. This means we need a column. Sales Amount= QTY* Price and then Sum(Sales Amount)

For Divide, we need to do Sum(A)/Sum(B). Discount % = Sum(Discount)/Sum(Sales)*100. Means we need measure.

 

Refer the pbix on this article - https://community.powerbi.com/t5/Community-Blog/Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners/ba-p/890814