Forum Discussion

LuITS's avatar
LuITS
Icon for Helper II rankHelper II
1 year ago
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'...
@Measures
  • LuITS's avatar
    LuITS
    1 year ago

    Hi, i actually had an error in my data. Thanks for your help anyways.

LuITS's avatar
LuITS
Icon for Helper II rankHelper II
1 year ago

Hi, thanks for youre reply but i get error.

 

When i try to use Measure 2 i get following Error:
Collumn Other Meassure not found or cant be used in this expression.

 

DAX of Other Meassure: DIVIDE(SUM('Table'[Quantity], SUM('Table'[Time])) * 60

FarhanJeelani's avatar
FarhanJeelani
Icon for Super User rankSuper User
1 year ago

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])) )

 

  • LuITS's avatar
    LuITS
    Icon for Helper II rankHelper II
    1 year ago

    Hi, i actually had an error in my data. Thanks for your help anyways.