web
You’re offline. This is a read only version of the page.
close
Skip to main content

Power BI

New

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].