cancel
Showing results for
Did you mean:

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

## Field Parameters, NOT Calculation Groups. SELECTEDMEASURE() functionality without Tabular Editor

FIELD PARAMETERS or CALCULATION GROUPS?
Both are used to dynamicaly change fields/measures in your report/visual.

1. It's more modern feature.
2. Covers Calculation Groups functionality.
3. Don't need external tools (like Tabular Editor).
4. You could use it together with over fields/measures.
5. Supports  individual values columns sort in matrix (How to sort values in pivoted columns

My favourite tutorial video for this topic by @AlbertoFerrari : Fields parameters in Power BI

Just one problem: how to pass selected measure as variable for another measure?
Example:
I have two almost identical measures:

``YTD Sales = CALCULATE([Sales], DATESYTD('Calendar'[DateKey]))``

and

``YTD Quantity = CALCULATE([Quantity], DATESYTD('Calendar'[DateKey]))``

But I want to reduce amount of measures and use something like

``````YTD = CALCULATE([Melected], DATESYTD('Calendar'[DateKey]))
//[Melected] - Measure sELECTED
//           - measure that could be equal [Sales] or [Quantity] depending on our slicer single choice/election``````

Here is amazing video by @pleblanc  dedicated to this topic:
REDUCE the # of measures with Calculation Groups In Power BI

Question: is it possible to get SELECTEDMEASURE() functionality without Tabular Editor?
Details: Desired functionality:

How To, a 5-step guide (the initial two steps being the focus of this article)

1) Let's create _MeasureSelected table and use it's [Melected Name] column as single choice slicer in our report:

2) Create [Melected] measure, that will be equal [Sales] or [Quantity] based on [Melected Name] slicer single choice:

3) Create [Melected] dependent measures like:

4) Create Field Parameter with list of measures:

5) Create matrix and Enjoy result

0 REPLIES 0

Announcements

#### Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

#### Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

#### The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors