SELECTEDVALUE from Slicer and include in calculated column

[JAllory]

Hello

I am new on powerBI desktop

I have a Tab DIM called Dim-WEEK with date and noweek

I have a slicer on noweek

I have a measure called selection :   Selection = SELECTEDVALUE('Dim-WEEK'[noWeek])

I have a TAb CLUSTERS with each line with one cluster and total number of cores

I want to add in my Tab CLUSTERS a calculated column taking the minimum value of Total number of cores versus sum of vcpu SQL

I have a Tab FACT with several calculated columns

               vcpu SQL = IF ([appli]= "SQL" ; MAX('MyFACT'[vcpu];4);0)

               vcpu SQLd = IF ([Week] = "31";'MyFACT'[vcpu SQL];0)

I want to replace "31" by the selected week so [selection] or directly SELECTEDVALUE('Dim-WEEK'[noWeek]

but it doesn't work L my other calculs are wrong

If I keep “31” equivalent of week 31 selected …my calculs are OK

Thanks to help to find What I have to do

[v-piga-msft]

Hi @JAllory,

Why not try with creating a measure to achieve that?

As I know, Power BI does not support dynamic calculate column based on slicer, we should use measure.

You could have a reference of this similar thread.

If you still need help, please share some data sample and your desired output.

Best Regards,

Cherry

[JAllory · Accepted solution]

Thanks a lot

Joelle

[JAllory]

Thanks a lot

Joelle