Measures - sum * Not sum

[Anonymous]

Hi All,

I have a problem with counting in measures.

I have two printouts with the same name, the number of printed pages is the same, the cost per page is e.g. 0.08
The query gives the result
day name number of pages cost

Day	Name	Number of Pages	cost pages
1	xxxx	4	0.08
3	xxxx	4	0.08

In the table in the Power Bi Desktop

I create tables

Name number cost per pages total cost

Name	Number of Pages	Cost of pages	TotalCost
xxxx	8	0,08	?????

I creat measures

TotalCost = CALCULATE(sum(query[pages])*sum(Query[costs_per_page])) is wrong sum pages and cost, when I want calculate 
TotalCost = CALCULATE(sum(query[pages])*Query[costs_per_page]) I get error

How to filtred or calculated? 

[PhilipTreacy]

Hi @Anonymous 

So did my suggestion fix your problem?

Regards

Phil

[PhilipTreacy · Accepted solution]

Hi @Anonymous 

Try this

TotalCost = CALCULATE( sum(query[pages]) * MIN(Query[costs_per_page]) )

Regards

Phil