Forum Discussion

DRNEWTR's avatar
DRNEWTR
Frequent Visitor
4 years ago
Solved

measure ratio calculating

How can i measure Ratio of _lineamount to total _lineamount columns     Like this ratio =   152/404=0,37 ??        
Need Help
  • jsaunders_zero9's avatar
    jsaunders_zero9
    4 years ago

    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

jsaunders_zero9's avatar
jsaunders_zero9
Icon for Responsive Resident rankResponsive Resident
4 years ago

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