Sums calculation

Question

Table is&nbsp;-----------------------------------------City&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Store&nbsp; &nbsp; &nbsp;Product&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;PriceToronto&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;TV1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;500Toronto&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;TV2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 550Ottawa&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;C&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Laptop1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 600Ottawa&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;D&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Laptop2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 650---------------------------------------------------&nbsp;I want to display like&nbsp;-----------------------------------------------------------City&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Store&nbsp; &nbsp; &nbsp;Product&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Price&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ratioToronto&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;TV1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 500&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;500/1050Toronto&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;TV2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 550&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;550/1050Ottawa&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;C&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Laptop1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;600&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 600/1250Ottawa&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;D&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Laptop2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;650&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 650/1250---------------------------------------------------&nbsp;How to create a new measure ratio to display the above picture?&nbsp;&nbsp;&nbsp;

rsbin · Accepted Answer

Anonymous ,
You can create 2 Calculated Columns:
TotalPrice = CALCULATE( SUM( [Price] ),
                ALLEXCEPT(YourTable, YourTable[City] ))

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

Hope this is what you are looking for.
Regards,

Forum Discussion

Sums calculation

2 Replies

Related content

SUM function doing wrongly calculation

Calculate sum without filters

PowerBI Wrong Total Sum calculation

Sum - Calculated Column

Calculate Sum MAX