measure ratio calculating

[DRNEWTR]

How can i measure Ratio of _lineamount to total _lineamount columns

 

Like this

ratio =   152/404=0,37 ??

[Ashish_Mathur]

Hi,

Try this measure

Line amount = sum(Data[_lineamount])

Line amount total = calculate([line amount],all(Data[_skuname]))

Ratio = divide([Line amount],[Line amount total])

Hope this helps.

[jsaunders_zero9 · Accepted solution]

Hi @DRNEWTR 

_LineAmount = SUM('Table'[LineAmount])
Total = CALCULATE(SUM('Table'[LineAmount]),ALL('Table'))
Ratio = DIVIDE([_LineAmount],'Table'[Total],0)

Try summing the Line Amount total by removing the filter using the All function, then divide this by the simple sum.

Let me know how you go.

Thanks James