Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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 ...
Need Help
  • v-luwang-msft's avatar
    v-luwang-msft
    4 years ago

    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's avatar
Ashish_Mathur
Super User
4 years ago

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.