How to multiply a measure with a static number?

[Anonymous]

Hi all,

I'm quite new in this PowerBI world and I would like your help on a measure who can multiply the results of a measure with a static number. 

So far I created a measure to calculate the emission performance at anchor:

Performance at Anchor =

CALCULATE(SUMX( Emissions, Emissions[Efficiency Anchor] - Emissions[Anchor [ton/day]]]),Emissions[Efficiency Anchor] >0)

All the results of this measure need to be multiplied by 0.0000383561643 to get the number of trees saved.

Can't seem to figure out how to do this, please help!

Many thanks,

Sharon

[Anand24 · Accepted solution]

Hi @Anonymous ,

You simply need to multiply in the same way you do in excel.

Considering you above DAX is working, your new dax would be below:

Performance at Anchor =
CALCULATE(SUMX( Emissions, Emissions[Efficiency Anchor] - Emissions[Anchor [ton/day]]]),Emissions[Efficiency Anchor] >0) * 0.0000383561643

Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!! Proud To Be a Super User !!! LinkedIn

[Anonymous]

Simple as that, works like a gem! Thanks @Anand24  😊