cancel
Showing results for
Did you mean:
Highlighted
Frequent Visitor

## average of an average to calculate further

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

1 ACCEPTED SOLUTION

Accepted Solutions
Frequent Visitor

## Re: average of an average to calculate further

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 .

6 REPLIES 6
Super User

## Re: average of an average to calculate further

Hi,

Give the sample output what u want exactly

Frequent Visitor

## Re: average of an average to calculate further

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

Super User

## Re: average of an average to calculate further

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

Frequent Visitor

## Re: average of an average to calculate further

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 .

Super User

## Re: average of an average to calculate further

cool !!!

Super Contributor

## Re: average of an average to calculate further

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