Sum measure instead of calculate

[Anonymous]

Hi all,

I want to sum the total meassurement instead of calculating it.

My data looks similar to this

Account number	KAM	Balance	Unpaid Item	Avg. price pr. item	Theoretical value (unpaid*avg.price)
1	A	10.000	250	150	37.500
2	b	15.000	0	100	0
3	c	5.000	15	350	5.250
Total		30.000	265	200	53.000

I want it to sum the total in "theoretical value" instead of calculating it, so the value should be (37.500+0+5.250) 42.750 instead of (265*200) 53.000

Right now I have tried following Dax code 

Theoretical value test = if( HASONEFILTER(''[Account Number]),SUM(unpaid item) * AVERAGE(avg. price pr. item), ???????)))

I dont know what to write instead of ????, to make it sum instead of calculate.

Can you guys help me? 🙂 

Thanks. 

[Tanushree_Kapse]

Hi @Anonymous ,
You can use this measure to fix the total for your Theoretical value column:
Theoretical(fixed)= SUMX(VALUE(KAM), [Theoretical value])


I hope this helps!

[Anonymous]

Hi, @Tanushree_Kapse,

I am not sure how to use the "theoretical(fixed), would you use it instead of ???? then`? 

[Tanushree_Kapse]

Hi @Anonymous ,
Not instead of that... this is completely new measure which you can pull in the visual.

[Anonymous]

@Tanushree_Kapse, i am sorry, but it doesent seem to work as I want to.

Is it a problem that "theoretical value" is a calculated value of "Unpaid" and "Avg. Price"?