Forum Discussion

ThomasWeppler's avatar
ThomasWeppler
Impactful Individual
3 years ago
Solved

SumX problems with variables

Hi Power BI community

I have a problem with the use of sumx and variables together.
Sumx doesn't show to total in my table.

 

Income =
var _closed = [Closed]
var _assinment = CALCULATE(SUMx(Invoice,Invoice[income]), (Invoice[invoicedate]) > _closed)
Return
IF(ISBLANK(_assinment),0,_assinment)
 
This gives me the right result on for each row, but doesn't sum up correctly

I have also tried to sumx the messaure
sumx Income = SUMX(Invoice, [income])
It gives the wrong results on each row, but add all the wrong results up.

I want to get the right results and add them up. Can anyone help me with that?
All help is greatly appreciated.
Need Help

2 Replies