Forum Discussion

Anonymous

Not applicable

2 years ago

Solved

Sums calculation

Table is ----------------------------------------- City Store Product Price Toronto A TV1 500 Toronto B ...

2 years ago

Anonymous ,

You can create 2 Calculated Columns:

TotalPrice = CALCULATE( SUM( [Price] ),
                ALLEXCEPT(YourTable, YourTable[City] ))

Ratio = [Price] & "/" & [TotalPrice]

Hope this is what you are looking for.

Regards,

Community Champion

2 years ago

Anonymous ,

You can create 2 Calculated Columns:

TotalPrice = CALCULATE( SUM( [Price] ),
                ALLEXCEPT(YourTable, YourTable[City] ))

Ratio = [Price] & "/" & [TotalPrice]

Hope this is what you are looking for.

Regards,

Anonymous

Not applicable

2 years ago

rsbin , Thank you for your help.

 ALLEXCEPT(YourTable, YourTable[City] )

means only use city filter.

I have a further question. I will post it in this forum.