Forum Discussion

Post Partisan

7 years ago

Solved

SUM function only accepts column reference as an Argument

Hey fellow power bi users, I am getting the following error: SUM function only accepts column reference as an Argument My DAX is as follow: Column = SUM(IF(AND(WEEKNUM(Data[dte_invduedate...

Need Help

v-juanli-msft

7 years ago

Hi Shamatix

it seems you write a column to put the formula which should be put in a measure.

If you'd like a column more than a measure, you could write columns as below:

total amount for all row

Column =
IF (
    AND (
        WEEKNUM ( Data[dte_invduedate], 2 ) >= WEEKNUM ( TODAY (), 2 ),
        YEAR ( Data[dte_invduedate] ) <= YEAR ( TODAY () )
    ),
    SUM ( Data[TotalAmount] ),
    0
)

total amount for each row

Column =
IF (
    AND (
        WEEKNUM ( Data[dte_invduedate], 2 ) >= WEEKNUM ( TODAY (), 2 ),
        YEAR ( Data[dte_invduedate] ) <= YEAR ( TODAY () )
    ),
    CALCULATE ( SUM ( Data[TotalAmount] ) ),
    0
)

Best Regards

Maggie

Shamatix

Post Partisan

7 years ago

themistoklis wrote:

Shamatix

Try the following formula on a Measure and not Calculated column

Measure =
CALCULATE (
    SUM ( Data[TotalAmount] );
    FILTER (
        ALL ( Data );
        WEEKNUM ( Data[dte_invduedate]; 2 ) >= WEEKNUM ( TODAY (); 2 )
            && YEAR ( Data[dte_invduedate] ) <= YEAR ( TODAY () )
    )
)

Hey Themis,

Thanks for the try, but didnt work.

As you can see it gives me the sum of ALL the rows in each row, I just want TotalAmount pr row where the statement at the top is valid, if it aint valid it should print 0,00 rather than the TotalAmount for the row.