Ignore a filter for a measure

[Anonymous]

Hi,

I would like to show a total sales measure on 1 chart, that ignores the sales person's contribution and
next to it should be the sales person's contribution.
Nothing seems to be working so far.

So the measure is:

Total Sales YTD = TOTALYTD([Total Sales];DATESYTD('Date Table'[Year-Month]))

So total for category and total for the chosen Sales person.

Thank you,

Gabor

[TomMartens]

Hey,

not sure without sample data, but maybe this will do the trick:

Total Sales YTD All SalesPerson= 
CALCULATE(
    TOTALYTD([Total Sales];DATESYTD('Date Table'[Year-Month]))
    ,ALL('<tablename>'[columnofthesalesperson])
)

Hopefully, this provides what you are looking for.

Regards,

Tom

[Anonymous · Accepted solution]

Hi @TomMartens 

The Measure you used worked great, but I did not see that there is another column for my filter as it was with table.
Image + name

So I had to write:

Total Sales YTD test 1 =

CALCULATE(

TOTALYTD([Total Sales];DATESYTD('Date Table'[Year-Month]))

;ALL('Adman (kisebb)'[2019 Sales]; 'Adman (kisebb)'[Képek])

)

Thank you so much! 🙂

[Anonymous]

Hi @TomMartens 

Unfortunately it did not work.
When i filtered for 1 sales person, the result was the same for the total sales and the sales person's contribution.

Total Sales YTD test 1 =

CALCULATE(

TOTALYTD([Total Sales];DATESYTD('Date Table'[Year-Month]))

;ALL('Adman (kisebb)'[2019 Sales])

)

So, 83M instead of 254M.