How to deal with numeric values in Dimension?

[Anonymous]

I have a ‘Project’ dimension and it has a discount value (in percentage). My problem is I cannot use a column from a Dimension directly in a measure…

I have to do Discount x Revenue. (Usually my dimension columns have only text values, but in this case its numeric).

Is it ok to do:

Measure1: = AVERAGE(Project[Discount])



Measure 2:= Measure1*Revenue

Or how do you achieve this? (My revenue is in my FactRevenue).

[johnt75 · Accepted solution]

You could do something like

Rev with discount = SUMX( FactRevenue, FactRevenue[Revenue] * RELATED(Project[Discount]) )