Create a secret measure table in Power BI!!

@jennytumay

2.1K followers · usually 1.9K views a post

Views

9.6K

Likes

108

Comments

7

Shares

8

SoundTikTok sound · original sound - jennytumay

Promoted product

Power BI

Sign in to Microsoft Power BI for intuitive data visualization, detailed analytics, and interactive dashboards. Unlock your data's full potential.

12 videos3 creators

Why it worked

The video provides a practical and visually clear demonstration of a useful Power BI feature, appealing to users looking to improve their data organization and workflow. The "secret" aspect and the promise of organization likely drove engagement.

Summary

This video demonstrates how to create a hidden measure table in Power BI to organize measures and expressions. It guides the viewer through entering data to create an empty table, naming it, and then adding a measure to it.

Structure

1Create an empty table for measures/expressions
2Name the table and column
3Close and apply changes
4Create a new measure within the new table

Original caption

Create a measure table in Power BI to organize your measures / expressions!! #powerbi #dataanalyst #microsoft #powerbitips #dataviz

More from @jennytumay

Product placement

Power BI is demonstrated as the software being used to create and manage measures and expressions.

On-screen text

Create a *secret* measure table in Power BI!! Measures/Expressions First Letter Count Measures/Exp... Wordle Strategy - Power Query Editor File Home Transform Add Column View Tools Close & Apply Close New Source Recent Sources Enter Data Data source settings Manage Parameters Refresh Preview Queries [2] Letters Previously Used Words 6 COLUMNS, 999+ ROWS Column profiling based on top 1000 rows Wordle Strategy - Power BI Desktop File Home Insert Modeling View Help Get data Excel workbook Power BI datasets SQL Server Enter data Wordle Strategy Apply changes Load Measures/Expressions Fields Search Letters Measures/Expressions Measures/Exp... Previously Used Wor... Table tools New measure Quick measure New column New table Measure Measures/Expressi... Structure 1 Measure = COUNT(ColumnName) Counts the numbers in a column Letters[Fifth] Letters[First] Check Create hierarchy New measure New column New quick measure Rename Delete from model Hide View hidden More options ...

Transcript

Create a measure table in Power BI!! I'm going to show you guys the best trick ever but I did not come up with it so don't get me wrong. I'm going to go back to the M query and click enter data. We're going to create an empty table. You can just call both the column and the table Measures/Expressions. So I'm going to call it Measures/Expressions. And then I'm going to click OK. So now we have a table called Measures/Expressions. And then we're going to go back to the Home tab and click Close & Apply. So now the changes have been applied. Load. Measures/Expressions. It's here. Now inside that table, under table tools, let's create a measure. Make sure the Home table is the empty table we just created. First Letter Count = COUNT(Letters[First]). This is just going to count the number of rows in the table. You can see the measure is in there. Click on the three dots and hide. Wow, so organized and pretty.