Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
We can get Calculated Measures in Tableau using Parameter in SQL. How can we replicate that in Power BI?
For example this:
I can't even access Parameters in Power BI in DAX panel
Solved! Go to Solution.
Parameters only apply to your queries. There are also What-If Parameters but those don't apply here. To get your desired functionality, you can make a disconnected table of values, make a slicer, and then use a SELECTEDVALUE() of that slicer column in a SWITCH expression.
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Parameters only apply to your queries. There are also What-If Parameters but those don't apply here. To get your desired functionality, you can make a disconnected table of values, make a slicer, and then use a SELECTEDVALUE() of that slicer column in a SWITCH expression.
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
User | Count |
---|---|
80 | |
74 | |
63 | |
61 | |
45 |
User | Count |
---|---|
108 | |
98 | |
89 | |
82 | |
61 |