Forum Discussion

Silver75's avatar
Silver75
Frequent Visitor
9 years ago
Solved

How can I multiply Measure per Column?

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  
Need Help
Tips and Tricks
  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    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. :smileyhappy:

    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

v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
9 years ago

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. :smileyhappy:

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

RZAU's avatar
RZAU
Frequent Visitor
3 years ago

In my senario, [Measure]*Max([Column]) is the best option.