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. I would recommend to start with Field Parameters, as far as: It's more modern feature. Covers Calculation Groups functionality. Don't need external tools (like Tabular Editor). You could use it together with over fields/measures. 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? Answer: Yes 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 P.S. Source file (Download)SELECTEDVALUE measure conflict with SELECTEDMEASURE
Hello guys! I implemented a drop-down menu on the dashboard as shown in the image below: I activated the measure inserted in the image above (SELECTEDVALUE) in the button in the type "Navigation on the page" to go to the selected page, so far so good. So this solution is in conflict with the solution to dynamically change measures in the Tabular Editor. As the image below: The result of the first solution is returning the result of the second solution. Is there a possibility to restrict the filters so that there is no conflict? Thanks in advance.
