Forum, Tips & Tricks

Learn tips and tricks and engage in discussions with our blog authors here. It’s all for your benefit and learning. 

Please or Register to create posts and topics.

Best practice: Keep measures organized in Measure Tables

After you create a measure it gets automatically placed in the table that is currently highlighted. This assignment, however, has no actual impact on the measure’s functionality since it is evaluated only based on the DAX code it contains. Placing measures in multiple tables with other actual data therefore may create confusion.

Power BI offers a handy functionality to keep things organized. Unfortunately, it is somewhat hidden so many users never think of doing it.

It is possible to create an empty table without any data and use it only for measures. This can be done by clicking on Enter Data on the main Home ribbon. You can name the table anything you want but I like starting the name with 0 since it then moves the table to the top of the list.

Now we have a table with one column that contains no data. We can put in a new measure now. We can still see the empty column in the table though.

To make things look even nicer, we right-click the column and select Hide. After that we need to reopen the .pbix file (weird I know) and we will see our new Measure Table with a fancy icon containing only measures.

Thanks a lot!

I’m stimulated alongside the surpassing additionally preachy outlining so that you can beautify these kinds of small timing. ASTM level 3

A debt of gratitude is in order for posting this information. I simply need to tell you that I simply look at your site and I discover it exceptionally fascinating and educational. I can hardly wait to peruse bunches of your posts. elta 8 THC

Hello, this weekend is good for me, since this time i am reading this enormous informative article here at my home. 台北音響店

I recently found many useful information in your website especially this blog page. Among the lots of comments on your articles. Thanks for sharing. 竹北音響店

I visit your blog regularly and recommend it to all of those who wanted to enhance their knowledge with ease. The style of writing is excellent and also the content is top-notch. Thanks for that shrewdness you provide the readers!

If you don"t mind proceed with this extraordinary work and I anticipate a greater amount of your magnificent blog entries. Ottawa Rims

Very nice article, I enjoyed reading your post, very nice share, I want to twit this to my followers. Thanks!. restaurant menu prices and hours

Deutschlands Wrestling-Magazin seit 1995: WWE & AEW, dazu die gesamte Wrestling-Welt. News, Ergebnisse, Hintergründe, Podcasts und mehr. Wrestling News