Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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
Thanks a lot
Joelle
Thanks a lot
Joelle
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
94 | |
74 | |
71 | |
64 |
User | Count |
---|---|
143 | |
109 | |
103 | |
82 | |
74 |