Calculate Dynamic Column Based on Slicer

[Anonymous]

Hi All,

I have recently started working on PowerBI..as per my knowledge (please correct me if I am wrong), the calculated columns do to not change values based on the slicer input..i.e. the calculated column values would only change should the data be refreshed... and measures can't have more than one value.As you can see below, PBI-SDFE(%) is a calculated column and the value from slicer is PBI-Final SDFE. PBI-SDFE(%) does not change based on the slicer(calculated column)..Is there anyway I can implement a dynamic column...? I tried using a measure as well, but since Lookupvalue returns a table of values rather than a single value, that does not work either...Any help in this regard would be appreciated....

[v-chuncz-msft · Accepted solution]

@Anonymous,

Just add MAX function in the measure.

https://community.powerbi.com/t5/Desktop/Comparative-last-30-days/m-p/325001#M144912

[Anonymous]

Hi Sam, 

Thanks for your help.

[Anonymous]

Hi sam, thanks for the reply.

But I want the output the in following format. (PBI-Average-Replenishment-Lead-time(Weeks) is the output column, and as you see, Lookupvalue is working fine but the calculation does not work...Below is the formula..Is there anyway that I can get dynamic column...

Thanks

PBI-Average-Replenishment-Lead-time(Weeks) = LOOKUPVALUE('IPM Model'[Avg. Replen. Lead-time (weeks)],'IPM Model'[Key],'IPM Model Simulation'[Key])*(1+'IPM Model Simulation'[PBI-Final LT])

[affan]

Hi @Anonymous

Please share some base data and the expected result. Please go through this post.

Regards,

Affan