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 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

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! :)

3 Replies

  • 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.
    • Anonymous's avatar
      Anonymous
      Not applicable
      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! :)