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

v-luwang-msft's avatar
v-luwang-msft
Community Support
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