Wrong summarized values visual table

Hi, Kjellke 

First of all, I can say that your needs are really not hard to achieve. But there are many contradictions between your sample and description, I hope you can explain it. Otherwise I can't test.

Without context, measure has only one value. How can it be calculated based on each row? You only mentioned the two columns you want, so what are the other columns in the visual?

In order to finally get the correct total, you may need write the code in the form of sumx(summarize()),so you only need to explain your calculation logic clearly (the text form is not the code you wrote), then I will help you modify it .

The sample data doesn't need to be much, it only needs to be representative, including the columns used for calculation.

I hope you can understand what I said and make changes so that I can help you soon.

Best Regards,

Community Support Team _ Janey

Dear v-janeyg-msft , i am sorry for the late response.

I have tried removing the filter on projtransposting[amountmst] as i could not remember why i had it in the first place.

The projtransposting[dataareaid]="100" is just a filter to use ERP data from the company that i am making the report for, as our ERP system has dummy data and other company codes. (Not really relevant for the calculations).

Projtransposting[Categoryid]="profit" is that the table is a transaction postlog where costs, revenues and profits are differentiated with the categoryid. I only want to extract values with the categoryid Profit.

Hope this explains more