Forum Discussion

JAllory's avatar
JAllory
Regular Visitor
8 years ago
Solved

SELECTEDVALUE from Slicer and include in calculated column

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

 

3 Replies

  • v-piga-msft's avatar
    v-piga-msft
    Icon for Resident Rockstar rankResident Rockstar

    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's avatar
      JAllory
      Regular Visitor

      Thanks a lot

      Joelle