topic Re: dividing a row value by sum of its column in DAX Commands and Tips

dividing a row value by sum of its column

Anonymous — Fri, 20 Nov 2020 20:30:15 GMT

I'm trying to add a column that that takes Ext Retail value (row level) and divides it by the sum of Ext Retail column value.

For example, the first row of $5007/$138,626 should return 0.03611. I tried a measure and calculated column but getting 1.00.

Any suggestions?

camargos88 — Fri, 20 Nov 2020 21:02:16 GMT

Anonymous ,

Try this:

Measure = SUM(TABLE[Ext Retail]) / CALCULATE(SUM(TABLE[Ext Retail]), ALL(TABLE[ITEM ID]))

camargos88 — Fri, 20 Nov 2020 21:25:11 GMT

Anonymous ,

You also can use the DIVIDE function, avoiding any error.