Division

[bassplayer-nld]

Hello,
I am trying to enter a new measure where I want to calculate a monthly usage based on a total annual number.
The column is called "Units Sold Sum" which I want to divide by 12.

The Units sold sum is already grouped and there are filter on the page.

Measure = ([Units Sold Sum]/12)

The error I get is that Power Bi cannot fine name Units Sold Sum

[amitchandak · Accepted solution]

@bassplayer-nld , In measure you have use sum

Measure = Sum([Units Sold Sum])/12

I have written this for target, but that may work in your case

#PowerBI Distributing/Allocating the Yearly Target(Convert to Daily Target): Measure ( Daily/YTD): Magic of CLOSINGBALANCEYEAR With TOTALYTD/DATESYTD: https://community.powerbi.com/t5/Community-Blog/Power-BI-Distributing-Allocating-the-Yearly-Target-C...

[Pragati11 · Accepted solution]

Hi @bassplayer-nld ,

In measure, you need to use a summarisation on column name like SUM, MAX, etc.

You can also try using DIVIDE function.

Measure = DIVIDE(SUM([Units Sold Sum]), 12, 0)

Thanks,

Pragati

[amitchandak · Accepted solution]

@bassplayer-nld , In measure you have use sum

Measure = Sum([Units Sold Sum])/12

I have written this for target, but that may work in your case

#PowerBI Distributing/Allocating the Yearly Target(Convert to Daily Target): Measure ( Daily/YTD): Magic of CLOSINGBALANCEYEAR With TOTALYTD/DATESYTD: https://community.powerbi.com/t5/Community-Blog/Power-BI-Distributing-Allocating-the-Yearly-Target-C...

[bassplayer-nld]

Thank you