Filter the graph with some values selected and some non selected

[krrish116]

Hi @amitchandak ,

I have a table with 

Name                 Talent                          Value

John                    Star                               5

John                   Gold                              6

John                   Diamond                       8

John                   (Blank)                           4

John                   System                         8

Carter                 Diamond                      4

Carter                 Star                               9

Carter               (Blank)                             4

Carter               System                           8

Greg                  star                                    7

Greg                 (Blank)                               7

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

In slicer we have Talent(Single Select).

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

On bars we are displaying the value of selected Talent 

On line we have to show the Percentage value like,

if the single select is on Star   then

Name            Bar               Line                             Calculation of Line

John               5             5 / (5+6+8)               Star value /  (Star + Gold + Diamond)  by eliminating (Blank) and System Value

Carter            9              9 / (9+4)

Greg              7              7  /  7

Please help me to solve it 

Thanks,

Krish..

[amitchandak · Accepted solution]

@krrish116 , Try like

total = sum(Table[value])
% Value = divide([total], calculate([total],not(isblank(Table[Talent])), allexcept(table, Table[Name])))

or
% Value = calculate(divide([total], calculate([total], allexcept(table, Table[Name]))),not(isblank(Table[Talent])))

[krrish116]

Hi @amitchandak ,

The (Blank) and System are values in that column and they came from database it self,

now i have to eliminate the (Blank) and System and calculate the Line Value.

[amitchandak · Accepted solution]

Try like

total = sum(Table[value])
% Value = divide([total], calculate([total],filter(table,not(isblank(Table[Talent])) && not (Table[Talent] in {"blank", "System"})) , allexcept(table, Table[Name])))

or
% Value = calculate(divide([total], calculate([total], allexcept(table, Table[Name]))),filter(table,not(isblank(Table[Talent])) && not (Table[Talent] in {"blank", "System"})))

You can remove blank in double quotes if needed

[amitchandak · Accepted solution]

@krrish116 , Try like

total = sum(Table[value])
% Value = divide([total], calculate([total],not(isblank(Table[Talent])), allexcept(table, Table[Name])))

or
% Value = calculate(divide([total], calculate([total], allexcept(table, Table[Name]))),not(isblank(Table[Talent])))

[krrish116]

Thankyou Very Much Sir...