Filter for a line graph

[shantupm5]

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

[joaoribeiro · Accepted solution]

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]

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

Have a good one!

[joaoribeiro · Accepted solution]

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]

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 · Accepted solution]

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]

Hello Joao,

Hope you are doing well,

I am futher looking for some help for the soultion you provided yesterday.

If we select multiple values from the Slicer, can we get the bar grarh with multiple values. instead of giving the bars with sum of the selected filters from slicerw.

For ex: If i select two or more values from the slicer, i would expect mutilple bar for each value i have selected from Slicer.

Please advice

[amitchandak]

@shantupm5 . Create a measure like

Averagex(Values(Customer[Customer]), Calculate(Count(Table[Order ID])) )

[shantupm5]

 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