Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Multiplying Single Values by A Measured Column Total in Table

I have numeric values (1,2,3,4,etc) in one column, and I want to multiply each of these values by the total of a different, measured column. Is this possible within Power BI?    For example, in Pow...
Measure Column Total
Measure Multiplication
Measures
Multiplying by Sum
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi,

 

I think I understand what you mean. I assume that you have either a product that you are shipping or a ship that is doing the shipping for which you have based the distinct count on? You seem to be missing a column in your table/visualisation. Anyway, if you apply an ALL() filter on that column, would this return you the Distinct Count Total?

 

For example, if the column that you are applying distinct count on is [ProductCode] then you could use:

Overall Average Cost:=CALCULATE([X/Distinct Count (Y)],ALL([ProductCode]))

With your Goal column then just multiplying distinct count Y by your overall average cost.

 

I think!