Calculated measures in Power BI Desktop reports connected live to SSAS Tabular.

May release of Power BI  Desktop adds the capability of adding new calculated measures to a report when you are connected live to SSAS tabular. This is great because before this release, once you connected live to SSAS you could not make any changes to the model. Official announcement

CalculatedMeasurePBIDLiveConnectTabularSSAS

Ideally the SSAS database has all the measures you need but now you have the capability to add new ones if you need to.

You can control the folder (table/measure group) under which the new measure shows up by using the “Home Table” option from the Modeling tab. I really like this feature as you can create copies of the same calculation and send them to different folders for ease of use.

Other SSAS related features

There is a request open for the same feature to be added for SSAS Multidimensional. Vote here:

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/19140997-calculated-measures-when-live-connected-to-mdx-cub

There is another request for adding calculated columns to a report connect to SSAS Tabular live. I recently ran into a situation where I wanted to create a custom column for sorting since it was not provided in the SSAS database and I did not have permission to modify the SSAS database.

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/19140907-create-calculated-columns-when-using-ssas-live-con

 

 

 

 

 

How to change the font size of the formula bar and measures grid in SSDT for SSAS Tabular

When you create a new measures in SQL Server Data Tools (SSDT) for SSAS Tabular, you edit the formula in the top section of the user interface in a section called “formula bar”. The default font size for this formula bar is 8.

formula_bar_font_size_8_default

The small font size may be difficult to read for some people. The easiest and fastest way to change the font size is to click somewhere in the formula bar and use your mouse middle wheel while holding down the Control button on your keyboard. However, the font size will go back to the default size next time you open SSDT.

If you wish to change the font size permanently, you can use the Tools menu. Click on Tools –> Options –> Fonts and Colors –> Environment and choose “Business Intelligence Designers” from the drop down menu. Here you can change the font size. Your changes will not take effect until you restart SSDT.

tools_options_environment_fonts_and_colors

The following pictures show my environment after I changed the formula bar’s font size to 10 and 14.

Font Size 10formula_bar_font_size_10

Font Size 14

formula_bar_font_size_14

Notice how the font size change affects the table results grid and the measures grid below as well. Also if you right click on any table name tab, the font size for the pop up menu has changed.

formula_bar_font_size_10_tables_right_click_menu

Font size 10 was the easiest to work with for me. It made the formula bar easier to read while it kept the rest of the environment at a good manageable size.