Forum Discussion
Using Column Total in Metrics
Hi I have below metrics data
Here I need another measure as TotalOrders so that it shows 71 for all Complaint codes for Less Than 1 Hr and so on for rest of the buckets.
Actually I wanted to create a % of orders for Complaint in a bucket so here for Arrived Warm for Less than 1 hr it would be 6/71 i.e 8.45%
Same way for Product Damaged/Crushed for less than 2 Hrs it woudl be 9/49 i.e. 18.43%
Your guidance is appreciated, kindly note this is metrics where columns are Buckets and rows are Complaint Notes.
Thanks
Hi Anonymous ,
Test the below :
create a new table2:
Table2 = SELECTCOLUMNS('Table',"VarCompCode",'Table'[VarCompCode],"Type",'Table'[Type]&" "&"%","value",'Table'[value]/CALCULATE(SUM('Table'[value]),FILTER(ALL('Table'),'Table'[Type]=EARLIER('Table'[Type]))))Then union the two table:
Table3 = UNION('Table',Table2)Fianl create the below visual:
Did I answer your question? Mark my post as a solution!
Best RegardsLucien
2 Replies
Hi,
Assuming the numbers there are a result of a measure, write this measure
% of total = divide([your measure],calculate([your measure],all(Data[Complaint Notes])))
Hope this helps.
Hi Anonymous ,
Test the below :
create a new table2:
Table2 = SELECTCOLUMNS('Table',"VarCompCode",'Table'[VarCompCode],"Type",'Table'[Type]&" "&"%","value",'Table'[value]/CALCULATE(SUM('Table'[value]),FILTER(ALL('Table'),'Table'[Type]=EARLIER('Table'[Type]))))Then union the two table:
Table3 = UNION('Table',Table2)Fianl create the below visual:
Did I answer your question? Mark my post as a solution!
Best RegardsLucien
