Parameter value is not populated correctly in new table using new column

[jayantatra]

I have defined a new parameter as below.

FG = GENERATESERIES(0, 100, 0.1)

FG Value = SELECTEDVALUE('FG'[FG])

However I am trying to call this value in another table using switch function, but the value shown is blank.

Column in another table : 

FG Value = SWITCH(TRUE(), CALCULATE(VALUES('Input data'[key new]))="Finished goods",'FG'[FG Value],1)

 

@amitchandak@Idrissshatila @mrcss23 

[v-rzhou-msft · Accepted solution]

Hi @jayantatra ,

Here I suggest you to create a measure instead of a calculated column in your data table. Power BI doesn't support us to show dynamic results catched by SELECTEDVALUE() function in calculated column, so it will return blank.

Measure:

M_FG Value =
SWITCH (
    TRUE (),
    CALCULATE ( MAX ( 'Input data'[key new] ) ) = "Finished goods", 'FG'[FG Value],
    1
)

Result is as below.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[jayantatra]

One more request pertaining the post, can it be converted to column somehow, as the calculation of totals is not done correctly in measure

.

[jayantatra]

Thank You @v-rzhou-msft , it is working perfectly