Measures Table Power BI

expertiseexcelerate

Measures Table Power BI  Discover how to create and utilize a Measures Table in Power BI to organize your calculations and improve report efficiency. This playlist is ideal for professionals, data enthusiasts, and Power BI users who want to streamline their DAX calculations and enhance the structure of their reports. In this course, we guide you through the process of building a Measures Table, explaining its benefits and how it can make managing your measures simpler and more efficient. By the end of this course, you’ll have a solid understanding of how to optimize your data models and reports with a well-organized Measures Table. What You’ll Learn: • How to create and organize a Measures Table in Power BI • The benefits of using a dedicated table for measures • Tips for streamlining DAX calculations and improving report management • Best practices for enhancing report performance and clarity with a Measures Table Ideal For: • Data Analysts and Business Intelligence Professionals • Power BI users seeking to better organize their reports and calculations • Anyone looking to improve their efficiency with DAX formulas and Power BI reports Subscribe to stay updated with advanced Power BI techniques and learn how to master the Measures Table for cleaner, more manageable data models.  Power BI Measures Table Tips Creating Measures in Power BI Power BI DAX Measures Explained Advanced Measures Table Power BI Power BI Measure Optimization Techniques Visualizing Measures in Power BI Power BI Measures vs Calculated Columns Best Practices for Measures Table in Power BI Power BI Measure Table Organization Power BI Measure Performance Tips  #PowerBI #DataVisualization #BusinessIntelligence #DataModeling #MeasuresTable #PowerBIDashboard #PowerBITutorial #DataAnalysis #Analytics #BusinessAnalytics #PowerBIMeasures #MicrosoftPowerBI #PowerBIforBeginners #PowerBICourse #DAX#PowerBITricks #LearnPowerBI #PowerBITips #PowerBIReporting #BeginnerPowerBI #PowerQuery #PowerBITutorialforBeginners #DAXPowerBI #BITool #Dashboard#DataDashboard #DashboardDesign #DataReporting

Transcript

00:00Hey friends, welcome back.

00:07In this short little video, I'd like to show you the so-called measures table trick.

00:11Now let me just maybe scroll down up here and make this smaller.

00:16And what you should see is currently our total sales measure is inside the sales table.

00:21Now the reason why it is currently in the sales table is because I right click on this

00:25table and create a measure from here.

00:28If I would create on this product table here for instance, right click here and then create

00:32a new measure, I could create the same measure like total sales, but then the measure itself

00:37would appear inside the products table, not in the sales table.

00:42So if I would like to actually make sure that all my measures are stored in the same table,

00:47then I could do the so-called measures table trick.

00:50The way this works is I can simply go to home and under home, I have the option to create

00:56a manual table.

00:57So by simply clicking on this edit data.

01:02Then here, I just need some kind of dummy value in here.

01:04So if I type in simply a one, that's totally fine.

01:07And I can name this table here and call it measure, measures, TBL, TBL is for table.

01:15And I think you cannot use the name measure directly because measure is I think a keyword

01:19in Power BI.

01:20That's why I call it measures TBL, but you can name it whatever you want.

01:25Then you click on load and just wait.

01:28And now we have another table in here, this measure table, right?

01:32Now what you could do is simply go to the measure itself here.

01:37And then we can here see in the table tools on this measure tools up there, then there

01:43is a name for the measure, we can rename it here.

01:46But also there is a home table and the home table can be changed here by simply going

01:51to another table.

01:52So if, for instance, for the sales, it's currently the sales table, but for the total sales measure,

01:57if I check the measures table now, click on it, you see that now if I do that, the total

02:03sales is now part of the measures table and not of the sales table.

02:09And now the magic trick comes, we need to go to the column number one, our dummy column,

02:14which we only need it in order to create this table.

02:17And then we click on the three dots here.

02:20And then we go in here and say we simply delete from one.

02:23And as soon as we do this, of course, we have here the pop up window just to make sure.

02:27Yes, we like to do that.

02:29And please watch what happens then for the measure table and the total sales.

02:32If I click on yes, then now automatically the measures table gets put on the top here.

02:39And also the icon changes.

02:41It's not a table anymore table icon, but instead it's this calculator icon.

02:46Because in this specific table, I only have measures, my total sales in this case, just

02:51one measure.

02:52But of course, I could have several measures in here.

02:54That's the measures table trick.

02:56So we have all our measures now, or we could create all our measures inside this measures

03:00table.

03:01So we have a better structure in here.

03:03And also they're always put on top here.

03:06And below there are all the tables we have.

03:08And also it has this little icon, this calculator icon, or several calculator icons here.

03:12And just to make sure that this is also an indication that this is our measures table.

03:17So this is just really, again, for structuring.

03:19It's not required in any way.

03:21You can also create your measures in all the tables and then just search for the measure

03:25here in the search bar.

03:26But I personally prefer to have my measures table here and all my measures in this table.

03:30And I can still use the search bar if I have too many measures.

03:34But this structure I really prefer because now my measures are always on top.

03:38And that's how you can do that.

03:40So you need to make sure that you have at least one measure and then you can create

03:45under home, as we've seen, under, in this case, enter data, a manual table, just with

03:49a dummy column.

03:51Then you simply put the measure inside this table and then you just remove the dummy column

03:57and then it automatically creates this measures table, puts it on top with the little icon

04:01here.

04:02Okay.

04:03So that's it for this video.

04:04Hopefully that was helpful and hopefully you can use this in your own home.

04:08So thanks a lot for watching and also of course for participating as always, and see

04:13you in the next video.

04:14Until then.

04:15Thanks guys.

Category

Transcript

Recommended