Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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 |
---|---|
98 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
59 |