Calculate dynamic measure with calculated column

[binayjethwa]

Hi , 

Can soeone help me with below issue. as per pic i have my values as below.

Variance , Performance are calculated columns and weight is a measure. I need another column as Final  =  Performance * Weight_ measure 

When i created a calculated column i see as below. but if you see for  first row performance is 60% and weight is 5.56 so my output should be around 3.36 % but i am getting 0.65%.

Variance = target-actual / target

performance = 100%- Variance 

weight = count of total rows in table / 100 based on slice selection (single or multiple)

Can someone help here please.

[Anonymous]

Hi @binayjethwa,

AFAIK, current you can't create dynamic calculated column based on filter effects.

They are work on different data levels, the measure dynamic calculate based on filter context parts will be fixed as static content when you use in calculated columns.

Notice: the data level of power bi(from parent to child level)

Database(external) -> query table(query, custom function, query parameters) -> data model table(table, calculate column/table) -> data view with virtual tables(measure, visual, filter, slicer)

Regards,

Xiaoxin Sheng

[amitchandak]

@binayjethwa , The final measure should be at row level of use group by

Final = Sumx(Table, [Performance] * [Weight_ measure])

or

Final = Sumx(Summarize(Table, Table[Line, Table[Item],Table[BLs], "_1", [Performance] * [Weight_ measure]), [_1])

[binayjethwa]

@amitchandak  i see below below values if i use the DAX shared.

 ideally for 3e's  it should be 60 % * 5.56  %= 3.36 and not 1.80. can u please check