dax formula to show total sold of a particular item

[BORUCH]

hi

i have my pivot table set up as follows

i would like to add a column next to the description that would tell me the total sales of apples for all salesman selected in this pivot table how can i get that done ?

Thanks

 

[MSBINinja]

See if this meets your requirements

Apple Sales =
CALCULATE (
    [Total Sales],
    KEEPFILTERS ( Fruits[Description] = "APPLES" ),
    ALL ( Employee[SalesPerson] )
)

 

[BORUCH]

See if this meets your requirements

Apple Sales =
CALCULATE (
    [Total Sales],
    KEEPFILTERS ( Fruits[Description] = "APPLES" ),
    ALL ( Employee[SalesPerson] )
)

Hi thanks for your answer

sorry for the inconvince i miswrote my question, i want it to be based on item number not description so whatever the item number is on column B it should show me total sales

but i dont want to hardcode it in the formula so whatever filters i have set for ex. year month salesperson etc. it shoud show me total sales for that item #

so the final number shoud be total sales for item 1 the only filter it should keep is the salesperson

 

[BORUCH]

so just to make it easier what i want i want a new column that would show me by item # 1 total qty sold was 15

 

[MSBINinja]

so just to make it easier what i want i want a new column that would show me by item # 1 total qty sold was 15

Can you please share your file?

 

[BORUCH]

Can you please share your file?

Good morning

i don't know how to upload a file but i can attach a better picture of what i'm looking for

 

[BORUCH]

Any updates ?

 

[MSBINinja]

Maybe this?

CALCULATE (
    [Total Sales],
    ALL ( Employee[Item] )
)

 

[BORUCH]

actually i figured it out the correct formula is

Sales Total for each product:=CALCULATE([Total Sales],ALLSELECTED(data[Salesperson]))