Tag: VertiPaq Power BI

Query Performance And DAX Studio Setup

This tutorial will discuss about setting up DAX Studio and measuring query performance in Power BI. These information will help detect bottlenecks in the query so that you can eliminate them and optimize your DAX. Setting Up DAX Studio Open the DAX Studio tool and connect your model. In this example, the EDNA Optimizing DAX

Continue reading

Power BI Filters: Invoking Context Transitions

Power BI Filters: Invoking Context Transitions

This tutorial will discuss about Power BI filters. You’ll learn how to see context transition in the xmSQL and the logical query plan. The context transition transforms the current row context into an equivalent filter context. The filters are then triggered by the CALCULATE function. The Importance Of The CALCULATE Function The CALCULATE function creates

Continue reading

DAX Calculation – Filter Context Transitions

DAX Calculation – Filter Context Transitions

In this tutorial, you’ll learn about how the storage engine can use the data model to compute information for your DAX calculation. It has the ability to use Left Outer Joins via the data model. The storage engine can do simple joins by having a one-to-many relationship in your data model or by using the

Continue reading

Power BI Storage Engine: Simple Math Operations

Power BI Storage Engine- Simple Math Operations

Today’s post will talk about how the storage engine in Power BI can do mathematical operations. This tutorial is helpful if you want to get combined figures without a column or a table. When dealing with easy measures or codes, the best practice is to send them into the VertiPaq storage engine. Unlike the formula

Continue reading

xmSQL Aggregations In VertiPaq DAX Studio

xmSQL Aggregations In VertiPaq DAX Studio

In this tutorial, you’ll learn about xmSQL aggregations. You’ll also understand how a storage engine in DAX Studio can greatly improve your report’s performance. There will be sample aggregations shown and used so that you can see how they perform in VertiPaq. There are two types of engines: the formula engine and the storage engine.

Continue reading