average of an average to calculate further

[modadda]

hi i am very new to using power bi, i need help with , sales data which returns on every line how much stock i got on hand, i therefore add it into the visuals  filter  as an average so it shows exactly how much i have .

i want to use the vlaues as i see in the visual that have the averages aplied , to be able to calculate  my stock levels by subtracting what i have on stock from another column of what my levels are 

so i need the average of qty on hand for every item as that is my stock on hand  

[Baskar]

Hi,

Give the sample output what u want exactly 

[modadda]

for an example if i sell product 'A' to 3 different customers it will show the current  qty on hand on every tranactions(Line) .

if it shows i got 5 on hand , that 5 will appear 3 times  and will show the sum of 15, i then changed it from sum to average in the visual filter , it then shows 3 on hand, as supposed to be.

i then have a minimum level for this item set to 50 

i need to subtract the qty on hand from my min level, to be able to see if i am stocking enough of the item

i require to create a formula that takes the average of the  qty on hand( which is my current stock holding) for the specific items

[Baskar]

sorry dude still i didn't get u .

Give me sample data and outp put in image , that will give more clear for me . 

sorry again 

[modadda · Accepted solution]

dude i came right , i had to use the measure instead of column to claculate what was needed...i went through a dax 101 tutorial and figured it out .

[v-ljerr-msft]

Hi @modadda,

Great to hear the problem got resolved!Could you accept your reply as solution to help others who has similar issue easily find the answer and close this thread?

Regards

[Baskar]

cool !!!