Using Column Total in Metrics

[Anonymous]

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

[v-luwang-msft · Accepted solution]

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 Regards

Lucien

[Ashish_Mathur]

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.