- Forums
- Get Help with Power BI
- Desktop
- Service
- Report Server
- Integrations with Files and Services
- Mobile Apps
- Developer
- Let's Talk Data
- Custom Visuals Development Discussion
- Community Support
- Welcome to the Community
- Community Feedback
- Community Help Blog
- Training and Consulting
- Dashboard in a Day
- EdX Specific Training Discussion Forum

Turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- Microsoft Power BI Community
- Forums
- Get Help with Power BI
- Desktop
- Re: How can I multiply Measure per Column?

Topic Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

Silver75

Regular Visitor

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

07-11-2017
05:03 AM

Hi everyone,

I'm building a report table similar to example

I need a new measure

new measure = Measure*Column.

Could you help me please?

thank you

Solved! Go to Solution.

1 ACCEPTED SOLUTION

Accepted Solutions

v-ljerr-msft

Super Contributor

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

07-12-2017
12:44 AM

Hi @Silver75,

The formula is ok but the grand total it's wrong

Based on my experience, using SUMX function could make it work. The formula below is for your reference.

New measure = SUMX ( 'TableNameOfProductDim', [Measure] * SUM ( [Column] ) )

Note: replace '**TableNameOfProductDim**' with the real table name of your **Product Dim** table which contains a column of individual value of ID PRODUCT.

Regards

6 REPLIES 6

Greg_Deckler

Super User

Re: How can I multiply Measure per Column?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

07-11-2017
06:13 AM

Is your "Measure" in your example a column or a Measure? If you need an actual measure, you will need to use an aggregation function like MAX, MIN or SUM like:

MyMeasure = SUM([Measure])*SUM([Column])

Otherwise, if Measure is an actual measure, then you shouldn't need the SUM for [Measure].

Proud to be a Datanaut!

Silver75

Regular Visitor

Re: How can I multiply Measure per Column?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

07-11-2017
06:25 AM

thank you for your solution. Measure is an actual measure. The formula is ok but the grand total it's wrong

Greg_Deckler

Super User

Re: How can I multiply Measure per Column?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

07-11-2017
06:48 AM

Yeah, that is not uncommon with measures. You generally have to do an IF with a HASONEFILTER or something along those lines to get the grand total to calculate correctly. Essentially, you can think of a measure in a grand total as your measure calculating in the context of ALL.

Proud to be a Datanaut!

v-ljerr-msft

Super Contributor

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

07-12-2017
12:44 AM

Hi @Silver75,

The formula is ok but the grand total it's wrong

Based on my experience, using SUMX function could make it work. The formula below is for your reference.

New measure = SUMX ( 'TableNameOfProductDim', [Measure] * SUM ( [Column] ) )

Note: replace '**TableNameOfProductDim**' with the real table name of your **Product Dim** table which contains a column of individual value of ID PRODUCT.

Regards

Highlighted
##

vmakhija

Member

Re: How can I multiply Measure per Column?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

12-09-2018
11:16 PM

In case my user is free to use whatever field they want, how does it work then?

I mean I can't put HASONEFILTER for multiple columns as such.

Any suggestions?

Regards

rtrohitsingh

Frequent Visitor

Re: How can I multiply Measure per Column?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

03-11-2019
10:51 PM

Hi Greg,

I have used the same formula to create Total Cost. I have used formula :

Total Cost = SUM(Sheet1[QtyShip])*sum(Sheet1[CuryCost])

But Total Visualizaion Total Amount is showing wrong value. I could not able to insert image.