Skip to main content

Power BI

Needs Votes

Get selections to be used in calculated measures

Vote (3) Share
Jure's profile image

Jure on 03 Aug 2016 22:00:48

Allow for selections to be available to use in calculated measures. i.e. put the list of selected values from a specific field (dimension) into a variable that can be used in a calculated measure.

A few use case examples:

- if a user selects "Product A" from [Products] dimension in a slicer, then show measure [Volume], else show measure [Quantity].

- if a user selects "Product XX" from [Products] dimension in a slicer, then show NULL, else show measure [No of Employees].