Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Ignore a filter for a measure

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 f...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    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! :)
TomMartens's avatar
TomMartens
Icon for Super User rankSuper User
7 years ago

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's avatar
Anonymous
Not applicable
7 years ago

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.