Calculation between Column table and Measure

[Chanleakna123]

Hi , Total Scheme Volumn is calculated , 

And Price is from the table without any calculation. 

I wanna have one calculation with = Total Scheme Volumn * Price , 
please aware that the Price Column can't be sum up , all apply for 6.11 . 

i try many calculation , it shown me the warning sign . 
Can you help me please ? in the mean time , look like the Price for Couple or Trade are sum up , actually , i dun want the price of Couple to be sum up , otherwise the calculation turn wrong from my side. 

[v-danhe-msft · Accepted solution]

Hi @Chanleakna123,

Based on my test, you could refer to below formula:

Measure = var total=CALCULATE(COUNT(Table1[Scheme]))
return CALCULATE(MIN(Table1[Price])*total)

Result:

You could also download the pbix file to have a view.

Regards,

Daniel He