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.
Comments