SUMIF cartesian(?) problem

Bennes — Tue, 26 Feb 2019 16:35:46 GMT

Hello,

I am quite new in powerBI so I am sorry if this is noob question.

I need to visualize sum number of whole projects portfolio, I am using SUM CALCULATE with FILTER criterias, however, when there are more invoice in certain month, SUM number is getting multiplied. I think it`s getting cartesian.

This is formula:

Portfolio =

var PM1='POHODA EXPORT'[PMs.PM]

var month1 =MONTH('POHODA EXPORT'[1.MM.YYYY])

var year1 = YEAR('POHODA EXPORT'[1.MM.YYYY])

return CALCULATE(SUM('POHODA EXPORT'[Amount]);FILTER('POHODA EXPORT';'POHODA EXPORT'[PMs.PM] = PM1 && MONTH('POHODA EXPORT'[1.MM.YYYY])= month1 && YEAR('POHODA EXPORT'[1.MM.YYYY])=year1))

I ma filtering portfolio based on YEAR, MONTH of invoice and Project manager.

I need the sum for certain month and certain project manager from list of invoices.

There can be 1 and more invoices per month.

For 1 invoice in 1 month, the formula works well. But with more invoices, number is getting multiplied by number of invoices.

What could be the solution for this problem? Is there any way how to group by in powerBI, or what would be the best please?

Thanks

topic SUMIF cartesian(?) problem in Developer

SUMIF cartesian(?) problem