Learn methods to exclude measures in calculation groups with DAX functions and Field Parameters

Описание: #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

🌏: https://perytus.com/
✍: https://perytus.com/blog/
📞: https://perytus.com/contact/