Multiply Column & Measure In DAX

[hegde86]

HI,

I have my data as below.

In this table 'Item Performance(Measure)' is a measure and it is calculated based on input selection on silcer. This needs to be multiplied with 'Weightage Based on Supplier Category'. This is static value which will be based Supplier Category (Gold, Silver Bronze).

Challenge is to generate  'Column_Final Item Performance' by multipliction of a column and a measure. Please help me to achive above.

[v-juanli-msft]

Hi @hegde86 

Is this problem sloved? 

If it is sloved, could you kindly accept it as a solution to close this case?

If not, please let me know.

Best Regards

Maggie

[v-juanli-msft]

Hi @hegde86 

You could only create a measure, calculated columns won't be change with the slicer, it is static.

Measure mutype = SUM('Table'[weight])*[Measure]

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-juanli-msft]

Hi @hegde86 

If tkrupka's suggestion doesn't help, please show me more details:

How to calculate the measure 'Item Performance(Measure)'?

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[tkrupka]

@hegde86 

See if this will meet your needs.

ColumnFinalItemPerformance  = CALCULATE ( SUM ( Weighted Based on Supplier Category) * [Item Performance])