#POWERBI #MICROSOFT #MICROSOFTPOWERBI #DAX #MICROSOFTPOWERBIDATAANALYSIS #DATAANALYSIS, #BUSINESSINTELLIGENCE #BI #PERYTUS #DECIPHERYOURDATA #DAX #CALCULATIONGROUPS #CALCULATIONITEMS #ISSELECTEDMEASURE #SELECTEDMEASURENAME #FIELDPARAMETERSPOWERBI
Calculation groups are powerful, useful, and provide a lot of functionality that is otherwise not possible but you need to be very careful and need a bit of planning when you are using calculation groups in your reports.
In this video, I will take a use case where we need to exclude measures from calculation groups, and I will deep dive into various solutions with the pros and cons of each solution.
Also, you will learn various DAX functions, also a different use cases of field parameters. End of the day, anything can be achieved with planning, and each solution has its own advantages and disadvantages.
Let me know what method you like, and why, and do share if you think there is another way to solve this.
Enjoy!!
00:00 Introduction
02:40 Problem Statement
04:00 Method 1 - SELECTEDMEASURENAME
07:13 Method 2 - SELECTEEDMEASURENAME and CONTAINSSTRING
10:13 Method 3 - ISSELECTEDMEASURE
14:20 Method 4 - Measure Table
18:53 Method 5 - Field Parameters
24:25 Summary
🌏: perytus.com/
✍: perytus.com/blog/
📞: perytus.com/contact/
- Learn methods to exclude measures in calculation groups with DAX functions and Field Parameters ( Download)
- Learn how precedence setting in calculation groups help in interaction between visuals - Power BI ( Download)
- Using calculation groups in DAX ( Download)
- Field Parameters vs Calculation Groups - which one to use in Power BI for a scalable solution ( Download)
- Select a Measure 👆 using a Slicer ✔️ and Calculation Groups ( Download)
- Best Practices and Pitfalls of Using Calculation Groups in Power BI: Insights from Parv Chana ( Download)
- Using the SELECTEDVALUE function in DAX ( Download)
- Power BI Office Hour 83: Introduction to calculation groups | Bernat Agulló Roselló ( Download)
- How to escape calculation groups and visual interactions pitfall in Power BI ( Download)
- Calculation Groups (with Kane Snyder) ( Download)
- Dynamic Power BI Report with Calculation Groups - Intro To Problem Of The Week #7 ( Download)
- DAX REVOLUTION! Visual Calculations in Power BI ( Download)
- How and where to write DAX Measures for Power BI and Excel ( Download)
- Power BI: Dynamic TOPN: Window, Field parameters, calculation groups ( Download)
- Power BI - Matrix Visualization - move values from columns to rows ( Download)
