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.
hi !
I have a table with 3 columns: Date, Sales and Cost.
I need to create the measures for sales and cost. in fact, too many of them.
My question is possible to dynamically change a column in a measure, like using the column name as parameter? For example:
Var ColumnSelected = SELECTEDVALUE(column) #Selection from a slicer using a table with rows with the same name of the columns in the fact table
Return
Sum(FactTable[ColumnSelected])
I checked some alternatives but all of them requires to create all the measures of each column and them use SWITCH.
Thank you
Solved! Go to Solution.
You'll need to use the SWITCH approach with a disconnected table, or a better way is to use a calculation group.
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Hi @Mp1977 ,
Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.
Best Regards
Lucien
You'll need to use the SWITCH approach with a disconnected table, or a better way is to use a calculation group.
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Thank you very much.
Switch requeires to create all the measures.
I will check the calclation group .
Hey, did you find a solution. Did it work?
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |