Calculation groups - Superuseful feature! TabularEditor by the way saved me when I needed to make Powershell script for refreshing token of office 365 account. It was the only tool (not SSMS) which showed the proper attributes of datasource parameters. Thank you SQLBI guys!

@radh6814

3 жыл бұрын

Interesting! Do you have any resource with explantion on how to get the refresh token with Powershell. I couldnt get it to work. Thanks for your help!

For large Central models this will dramatically cut down duplication in Dax tables. Thanks Marco!

This is great! A simple but so effective update. Finally we can get currency symbols into our finance reports :). Thanks Marco!

Wow, that is fantastic. Thanks for the good news!!

WOW! This is amazing! Hands down the best new feature in the past 3 years. Love it. Marco, any performance watch outs?

@marcorusso7472

4 жыл бұрын

It depends on the DAX you write. Calc groups by themselves are neutral regarding performance.

awesome update to apply to financial reports!

It is game changer.. Waiting for extended discussion in mastering dax course including your insights and best practises

@marcorusso7472

4 жыл бұрын

We already have a module about calculation groups in the Mastering DAX video course. You can now download the same examples in Power BI in the articles linked here: www.sqlbi.com/calculation-groups/

Thanks a lot! Excellent news!

thanks again for this great content! Calc Groups sound were promising will play with that. which AS compatbility level is needed, 1500? If we now would get in addition also "default members" feature, so we don't need anymore insure that a slicer has always a value set, this would be another nice edition and would and narrow the gap to OLAP cubes even more ;)

You dax book, mentioned in this video, is missing pages on the kindle version. Though you might want to know.

@SQLBI

3 жыл бұрын

Please, can you provide us a reference so we can further investigate? Thanks!

That's an awesome feature! But since Formulas go into columns on Matrix... does it keep sorting functionality? or sorting becomes no longer available by column?

@marcorusso7472

4 жыл бұрын

Just watch the next video, Creating calculation groups in Power BI Desktop using Tabular Editor: kzread.info/dash/bejne/k2iuu7ZmfpDgo7g.html You can control the sort order of the calculation item in Tabular Editor by just using drag&drop!

thanks, with calculation groups is possible to create dynamic tooltips?

@marcorusso7472

4 жыл бұрын

Calculation groups affect existing measures, but don't generate new measures. Tooltips are defined by Power BI measures you apply to the Tooltips property, so they are affected by calculation groups, but you still need to associate measures to tooltips to get the result.

Thank you Marco. Can we rely on Power BI PRO, to maintain and support the functionality in the future? I don’t want to generate reports with methods that I’m not sure will be supported in the future. Thanks again.

@marcorusso7472

4 жыл бұрын

It is a supported feature in Power BI Pro.

@matemusic

3 жыл бұрын

Thank you :)

Hi sir, thanks for your great job. I have a question that how can I use those measure into visualize. After create calculate group, I no longer see those measure to visualize. Thanks

@SQLBI

3 жыл бұрын

Calculation groups only work with explicit measures and they disable implicit measures. just create the measures you want in an explicit way (which is also a best practice in any case - otherwise Excel cannot use your model).

Is that the base measure (sales amount, margin) should be in corresponding table, or we can use the measure table which are created in common?

@marcorusso7472

4 жыл бұрын

Measures belong to the model, you can use them regardless of the table where they are created.

@sarva0483

4 жыл бұрын

@@marcorusso7472 Thanks

Hi Marco, i have a question, does this only work on a matrix table?

@marcorusso7472

4 жыл бұрын

The measures are affected by calculation groups for all the visuals, and this already works. The Power BI Desktop July 2020 version only applies the dynamic format string of a calculation group to Matrix, Table, and Card visual. However, Microsoft should implement the dynamic format strings for other visuals in future versions of Power BI.

@marcorusso7472

3 жыл бұрын

Good news - Microsoft updated Power BI Desktop July 2020 version and if you download it after August 1, it works with charts, too!

Hey Marco, is it only possible with time intelligence with date on rows?

@SQLBI

3 жыл бұрын

No you can have the date filter applied on columns, slicers, or in the filter pane.

Ciao Marco, does this mean that the calculation groups are supported in the Power BI Pro service as well?

@ragberends

4 жыл бұрын

I managed to do a hack and it is working!

@marcorusso7472

4 жыл бұрын

Yes, it works in Power BI Pro as well!

@ronvdlaan1

4 жыл бұрын

How can i enable this feature in PowerBI desktop, i see external tools but Tabular Editor is disabled

@marcorusso7472

4 жыл бұрын

@@ronvdlaan1 If you don't see the Tabular Editor icon in External Tools, make sure you install the latest version of Tabular Editor first!

@ronvdlaan1

4 жыл бұрын

@@marcorusso7472 Hallo Marco, I did it today with a download form SQLBI.COM

Hi Marco, since this is a third party feature, what about data security?

@marcorusso7472

4 жыл бұрын

The Tabular Editor works locally and unlocks features that otherwise are not available in Power BI Pro. It is up to you to evaluate the security. If you want to do a security assessment, source code of Tabular Editor is available at github.com/otykier/TabularEditor

Anyone know why it doesnt work when connecting tabular editor to a dataset in the power bi online service and trying to add a calc group?

@SQLBI

3 жыл бұрын

If you connect Tabular Editor to Power BI online, the dataset must be on premium capacity and you should connect using XMLA endpoint. Make sure you set the "Discourage implicit measure" model property to False and that you have a compatibility level greater than or equal to 1520. These steps are automatic if you save the PBIX file after you enable the preview property "Store datasets using enhanced metadata format".

Hi Marco, Could you please help me to identify the property "Discourage Implicit Measures' to enable Calculation groups feature in Power BI

@marcorusso7472

4 жыл бұрын

That property is at the Model level and it is automatically set to True as soon as you create a calculation group in Tabular Editor. However, make sure you enable the preview feature “Store datasets using enhanced metadata format” in the Power BI options in order to create calculation groups.

@Sandhyaansoman

4 жыл бұрын

@@marcorusso7472 Yes that is also enabled. But I tried to migrate the model from A(AS) to Power BI through Tabular editor. Then I tried to create the calculation group in that PBIT file. Is that the one causing this issue?

@marcorusso7472

4 жыл бұрын

@@Sandhyaansoman You have to upgrade the compatibility level by doing this: - Enable the preview feature “Store datasets using enhanced metadata format” in the Power BI options - Open the PBIX - Save it as a PBIX (now it should have the new format) Now you should be able to open Tabular Editor and create the calculation groups. The compatibility level and the setting you mentioned should be updated automatically this way.

@Sandhyaansoman

4 жыл бұрын

@@marcorusso7472 Thank you so much !!!

It seems that when you start to use Tabular Editor and experiment with calculation groups, Power BI will stop to have default option to use the default sum,count,average measure in the model. Explanation: you take one colum from table, add it to your visualization (f.e. Matrix), click on the drop down arrow an have an option to choose Dont Summariye, count, sum, etc... this is not the case when you add calculation group to your data model. Link to ISSUE: community.powerbi.com/t5/Desktop/Tabular-Editor-Calculation-groups/m-p/1283596#M561212

@SQLBI

3 жыл бұрын

It is not a bug, it is by design. Calculation groups disable implicit measures. You can see this described in the documentation, too. docs.microsoft.com/en-us/analysis-services/tabular-models/calculation-groups?view=asallproducts-allversions

@jakubkalab1914

3 жыл бұрын

@@SQLBI Thanks for you replay and explanation. Just side question, is it possible somehow active this capability (implicit measures) back in model/power BI? I try to remove all the calculation groups from the model, but I can see no change in functionality (no implicit measures). Thanks again for your time.

@SQLBI

3 жыл бұрын

@@jakubkalab1914 You need to change the "Discourage implicit measure" setting in the data model using Tabular Editor. It is set to True when you create a calculation group, but it is not automatically reset to "false" when you remove them.