Filter for a line graph

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

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