cancel
Showing results for
Did you mean:
New Member

## Division

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
2 ACCEPTED SOLUTIONS
Super User IV

@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...

Proud to be a Super User!

Super User III

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

If this helps, Appreciate a KUDOS!

Proud to be a Super User!

3 REPLIES 3
Super User III

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

If this helps, Appreciate a KUDOS!

Proud to be a Super User!

Super User IV

@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...

Proud to be a Super User!

New Member

Thank you

Announcements