Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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..
Solved! Go to 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])))
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
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.
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
@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])))
Thankyou Very Much Sir...