Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Measures - sum * Not sum

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 resul...
Need Help
Show and Tell
  • PhilipTreacy's avatar
    PhilipTreacy
    5 years ago

    Hi Anonymous 

    Try this

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

    Regards

    Phil

PhilipTreacy's avatar
PhilipTreacy
Super User
5 years ago

Hi Anonymous 

Try this

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

Regards

Phil