Forum Discussion
Solved
DAX Measure, Total is wrong
Hello I have problems converting formulas into DAX measure, Measure 1: SUM(Quantity) / SUM( Quantitiy / Goal ) My try: DIVIDE('Table'[Quantity], SUMX('Table', DIVIDE('Table'[Quantity], 'Table'...
Hi, i actually had an error in my data. Thanks for your help anyways.
Use below:
Other Measure:
Other Measure = DIVIDE(SUM('Table'[Quantity]) + SUM('Table'[Time]), 1) * 60
Measure 2:
Measure 2 = DIVIDE(
[Other Measure], SUMX('Table', DIVIDE('Table'[Quantity], 'Table'[Goal])) )
Hi, i actually had an error in my data. Thanks for your help anyways.