Forum Discussion
Table not showing summarized values
Hi, i am quite new to Power BI, but i am trying to make some with data ive successfully exported from our ERP system. I am now trying to have two collumns that one that summarize the positive numb...
After hours on google i have now tried the following formula with no success.
FORMULA =
VAR _UTTAK = CALCULATE(SUMX(PROJTRANSPOSTING,PROJTRANSPOSTING[AMOUNTMST]),PROJTRANSPOSTING[ACCOUNT]="2901")
VAR _UT = CALCULATE(SUMX(PROJTRANSPOSTING,PROJTRANSPOSTING[AMOUNTMST]),PROJTRANSPOSTING[POSTINGTYPE]<>122)
VAR _INN = SUMX(PROJINVOICEJOUR,PROJINVOICEJOUR[FAKTURERT])
return IF(_INN-_UT-_UTTAK<0,_INN-_UT-_UTTAK,0)