Forum Discussion

shantupm5's avatar
shantupm5
Helper III
3 years ago
Solved

Filter for a line graph

Hello,

 

I have two metrics on a line graph, 

1) Sum of Orders booked for all the customer

2) I want to show sum of orders booked per customer 

 

I want to compare 2nd metrics with 1 buy changing / applying a filter to the customer name. Where and how i can apply a filter for second metrics//

 

 

Please advice

 

Regards

Prashanth

Need Help
Show and Tell
Tips and Tricks
  • joaoribeiro's avatar
    joaoribeiro
    3 years ago

    Hi shantupm5 ,

    I believe you should create the two metrics changing the filter, as shown below:

    1) Sum of Orders booked for all the customer

    CALCULATE(
SUM(OrdersBooked),
ALL(Customers)
)

    2) I want to show sum of orders booked per customer

    SUM(OrdersBooked)

     

    With the ALL() function, the first measure will ignore the Customer filter, and the second measure will consider the Customer filter to show the sum for the specific customer(s) filtered.

     

    Hope this answer solves your problem!
    If you need any additional help please @ me in your reply.
    If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍

    Thanks!

    Best regards,
    Joao Ribeiro

  • joaoribeiro's avatar
    joaoribeiro
    3 years ago

    Hi,

     

    The second measure (below), will be responsive to any filter applied in the report, so if you add a Slicer for the customers and select specific customers, it will show the OrdersBooked only for them.

    SUM(OrdersBooked)

     

    Hope it helps!


    Best regards,
    Joao Ribeiro

7 Replies

  • joaoribeiro's avatar
    joaoribeiro
    Impactful Individual
    3 years ago

    Hi shantupm5 ,

    I believe you should create the two metrics changing the filter, as shown below:

    1) Sum of Orders booked for all the customer

    CALCULATE(
SUM(OrdersBooked),
ALL(Customers)
)

    2) I want to show sum of orders booked per customer

    SUM(OrdersBooked)

     

    With the ALL() function, the first measure will ignore the Customer filter, and the second measure will consider the Customer filter to show the sum for the specific customer(s) filtered.

     

    Hope this answer solves your problem!
    If you need any additional help please @ me in your reply.
    If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍

    Thanks!

    Best regards,
    Joao Ribeiro

    • shantupm5's avatar
      shantupm5
      Helper III
      3 years ago

      Hello, 

       

      First issue did resolve, but looks like i did not get the second solution "and the second measure will consider the Customer filter to show the sum for the specific customer(s) filtered." I dont see the formula filtering out or showing up any filters to select the list of customers to manually filter. Please advice

       

       

      • joaoribeiro's avatar
        joaoribeiro
        Impactful Individual
        3 years ago

        Hi,

         

        The second measure (below), will be responsive to any filter applied in the report, so if you add a Slicer for the customers and select specific customers, it will show the OrdersBooked only for them.

        SUM(OrdersBooked)

         

        Hope it helps!


        Best regards,
        Joao Ribeiro

    • shantupm5's avatar
      shantupm5
      Helper III
      3 years ago

       Thanks Amit for your quick response..

       

      I think this solultion is not working, What i am looking is to apply a filter for one of the line graph out of two, If i select values from the filter, the filter should be applied only for one line graph out of two available in chart.

      Do we have any solution for this requirement? Please advice

       

  • shantupm5's avatar
    shantupm5
    Helper III
    3 years ago

    Thank you so much! It did help me with the solution you provided!

     

    Have a good one!