Exploding Measures using Tabular Editor 3

Exploding Measures using Tabular Editor 3

Tabular Editor 3 presents an opportunity to explore exploding measures and gain a better understanding of how to remove references to a measure within a dashboard. In this context, "exploding" means expanding or removing any reference to a measure inside another measure. For instance, say you have three measures: Total Sales = SUM(Sales[ExtendedAmount]), Total All Product Sales = CALCULATE([Total Sales],ALL(Products)), and ultimately, % All Product Sales = [Total All Product Sales] / [Total Sales].

To remove all connections to [Total Sales] in [% All Product Sales], you must first develop [Total All Product Sales] by expanding it. This tutorial explores the step-by-step process of using Tabular Editor 3 to accomplish this goal. By adopting these measures, you can expand your understanding of measures and refine your knowledge of all things data-driven.

Whether you are a seasoned data analyst or just getting your bearings in the field, the insights uncovered in this tutorial are valuable in refining your data visualization skills and giving you a foundation for powerful storytelling. To dive deeper into the concept of exploding measures and gain a wider perspective on how they can be applied to a variety of dashboard solutions, read the full tutorial using the link below.

Read More »

Published on:

Learn more
Power BI Live Training - Power BI Online Training - Excelerator BI
Power BI Live Training - Power BI Online Training - Excelerator BI

Australian Power BI training ✅ Power BI online training ✅ Learn Power Query online ✅ Power BI expert, Matt Allington (MVP) ✅ Best in class Power BI book

Share post:

Related posts

Understanding What Data Modeling Is And Creating The Right Relationships

In this tutorial, you'll learn about the concept of data modeling and how to create the right relationships between different data tables in y...

2 months ago

Data Visualization Technique in Power BI – Multi Measure Dynamic Visuals

In this blog post, you'll discover a powerful data visualization technique that will take your Power BI analysis to the next level — the...

2 months ago

Use Tabular Editor To Create Calculation Groups In Power BI

Looking to get started with calculation groups in Power BI? Look no further than this informative blog post, which provides an in-depth introd...

2 months ago

Turning Calendar Type Layout Into Tabular Format In Power BI Using Query Editor

Does arranging your data in Power BI feel like a challenge? This tutorial is here to guide you in transforming your calendar type layout into ...

2 months ago

Data Modeling for Mere Mortals – Part 2: Dimensional Modeling Fundamentals

This article is the second installment in the "Data Modeling for Mere Mortals" series, where you'll delve into the fundamentals of dimensional...

12 months ago

[DAX] Window Functions & Tabular Editor 3 (with Daniel Otykier)

In the Power BI December 2022 update, several new DAX functions were introduced, and they have been making waves in the analytics community ev...

1 year ago

Tabular Editor for Beginners

If you're new to Tabular Editor, this video tutorial is the perfect entry point for you. Through a step-by-step approach, you'll gain a solid ...

1 year ago

Mastering DP-500 Exam: Optimize Data Model with Tabular Editor

For many data analysts, transforming unwieldy data models into sleek efficiencies is a time-consuming and often frustrating process. However, ...

2 years ago

Using Macros in Tabular Editor 3

Tabular Editor 3 is an outstanding tool that can significantly boost your productivity when it comes to data modelling in Power BI. In this po...

2 years ago
Stay up to date with latest Microsoft Dynamics 365 and Power Platform news!
* Yes, I agree to the privacy policy