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

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

Accepted Solutions

## 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-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

All Replies

## 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].

**Did I answer your question? Mark my post as a solution!**

Proud to be a Datanaut!

## 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

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

**Did I answer your question? Mark my post as a solution!**

Proud to be a Datanaut!

## 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-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

## 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