Forum Discussion

Kjellke's avatar
Kjellke
Helper I
4 years ago

Wrong summarized values visual table

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...
Need Help
Kjellke's avatar
Kjellke
Helper I
4 years ago

Dear Janeyg,

The code does not provide me with the correct numbers. The VIA collumn is just the same as the other collumns but without the IF function.

Do you know how i can export samle data?

Please see below for the VIA code

VIA = 
VAR _profit = CALCULATE(SUMX(PROJTRANSPOSTING,PROJTRANSPOSTING[AMOUNTMST]),PROJTRANSPOSTING[ACCOUNT]="2901",PROJTRANSPOSTING[DATAAREAID]="100",PROJTRANSPOSTING[CATEGORYID]="Profit")

VAR _kost = CALCULATE(SUMX(PROJTRANSPOSTING,PROJTRANSPOSTING[AMOUNTMST]),PROJTRANSPOSTING[POSTINGTYPE]<>122,PROJTRANSPOSTING[COSTSALES]=1,PROJTRANSPOSTING[AMOUNTMST]<>.000000000000)

VAR _fakturert = SUMX(PROJINVOICEJOUR,PROJINVOICEJOUR[FAKTURERT])

return _fakturert-_kost-_profit
Kjellke's avatar
Kjellke
Helper I
4 years ago

v-janeyg-msft 

I tried to make an example in Excel as it may be easier to explain.
Please see if this helps to understand what i am trying to achieve,  i am sorry for the poor descriptions.