Unfortunately, it does happen… You have just added a new calculation group/calculation item to your model and all of the sudden, some of the visuals on your report stop working. Usually, the main reason behind is some sort of invalid DAX in your calculation group. However, sometimes this might happen even if on a surface … Continue reading What to Do When Calculation Groups Break Your Measures (PowerBI Tutorial)
Tag: DAX
Power BI & DAX: How to Use Breadcrumbs to Fix the Fatal Flaw of the Filter Pane
in this video I talk about the fatal flaw of the Power BI's Filter pane and how we can fix it with breadcrumbs. What fatal flaw am I talking about? What the heck is a breadcrumb? Well, watch the video and you will find out. https://youtu.be/6HHbPzqhcn8 These are the measures that I have created to … Continue reading Power BI & DAX: How to Use Breadcrumbs to Fix the Fatal Flaw of the Filter Pane
Microsoft SQL Server 2012 With PowerView For Multidimensional Models is available in CTP
Microsoft demonstrated PowerView on top of the Multidimensional model in Analysis Services several weeks ago at SQL PASS and now the CTP version of the product is available here. There are two pieces of new functionality delivered with this CTP: Update for Analysis Services engine to allow DAX support for Multidimensional models Update for the … Continue reading Microsoft SQL Server 2012 With PowerView For Multidimensional Models is available in CTP
Dynamic security in a tabular model for analysis services
The second iteration of the tabular model for analysis services now allows us to implement very sophisticated security scenarios including row-level dynamic security. In order to implement it, first we need the means of finding out the windows credentials of the user. That can be accomplished using the DAX function USERNAME(). Second, we need to map … Continue reading Dynamic security in a tabular model for analysis services
Microsoft SQL Server 2012 Virtual Labs
Microsoft has posted 16 virtual labs online. The labs cover three major areas: Business Intelligence Mission Critical Operations Database Management Those of us who are trying to jump start Self Service BI in our organizations should checkout the following three: Creating a PowerPivot Model and Report in the Excel Client Defining DAX Calculations with Microsoft … Continue reading Microsoft SQL Server 2012 Virtual Labs
Parent Child in PowerPivot
EDIT: I recorded a detailed video on how to work with Parent Child hierarchies in Power BI: https://businessintelligist.com/?p=2603 Kasper de Jonge posted a great article about building PowerPivot hierarchies against dimension tables that implement parent/child relatioship... Basically, a new PATH() DAX function is used to build a string that contains a path from the leaf … Continue reading Parent Child in PowerPivot
business intelligist 