Solved: How to get Calculated Measure using Parameters?

Anonymous · ‎07-15-2021

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

mahoneypat · ‎07-15-2021

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

Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.

@mahoneypa HoosierBI on YouTube

View solution in original post

mahoneypat · ‎07-15-2021

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

Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.

@mahoneypa HoosierBI on YouTube