cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Anonymous
Not applicable

## 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

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

#### Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors