Filter the graph according to selected and total sum of all values

[krrish116]

Hi @amitchandak ,

I have a table with 

Customer          Product        Value

John                    car                5

John                    bike              6

John                   plane             8

Carter                car                  4

Carter               plane              9

Greg                 bike                7

Greg                 plane              7

In the report we have a slicer and Bar and Line Graph

In slicer we have Product (Single Select).

In bar and line graph we are showing Customer on X-Axis and in Y- Axis we have to show

On bars we are displaying the value of selected product 

On line we have to show the Percentage value like,

if the single select is on Plane then

Customer      Bar               Line                             Calculation of Line

John               8             8 / (8+6+5)              Plane Value / Car +Bike+ Plane

Carter            9              9 / (9+4)

Greg              7              7  /  (7+7)

Please help me to solve it 

Thanks,

Krish..

[amitchandak · Accepted solution]

@krrish116 , Try measure like

Bar = sum(Table[Value])
Line = divide([total], calculate([total], allexcept(table, Table[Customer])))

[krrish116]

Thank you @amitchandak