Power BI

Needs Votes

Support creating calculation groups in Power BI Desktop

Vote (2626)

Marco Russo on 20 Mar 2019 01:59:47

Support the creation of DAX calculation groups in Power BI Desktop - otherwise Power BI can only consume calculation groups created in Analysis Services, whereas it would be very useful to have this feature in any Power BI model.
Even just a simple text window with a script would be fine. You can clean up the UI later.
Thanks.

Administrator on 30 Jul 2020 16:56:44

This is in our backlog. Stay tuned for more updates!

Comments (43)

Comments (43)

Andrei Saygo on 31 Jan 2023 18:16:13

RE: Support creating calculation groups in Power BI Desktop

9edb1a7c 79eb-ea11-a817-000d3a8faea9 on 31 Aug 2020 11:08:14

RE: Support creating calculation groups in Power BI Desktop

Hi all,

this was acutally solved with PowerBI August 2020 version.
It now allows you to use external tools and you are able to create calculation groups with the external tool "Tabular Editor".
https://www.youtube.com/watch?v=a4zYT-N-zsU

d95964ff 7cdd-4789-8f4f-549b3bf22de6 on 23 Aug 2020 20:15:40

RE: Support creating calculation groups in Power BI Desktop

Although the current Calculation Group solution is great and offers many opportunities there are some important updates needed for Calculation Groups:

- KPI support (symbol and color support)
- data bar support in Powerbi matrix on selected calculation group item(s) while having 1 measure with multiple calculation group items on columns.

f14fb61c e288-485e-8b06-b56b36b316ab on 06 Jul 2020 00:17:13

RE: Support creating calculation groups in Power BI Desktop

please prioritise this as it's an amazing tool

a3309361 99be-ea11-a812-000d3a8ddfb2 on 06 Jul 2020 00:13:44

RE: Support creating calculation groups in Power BI Desktop

Please prioritize!

1b346d83 7901-4df8-8bbe-69b2a7d0da5a on 06 Jul 2020 00:13:34

RE: Support creating calculation groups in Power BI Desktop

This really needed since workaround switching measures have serious performance issues.

fae07792 b99d-4161-8b26-d0c558baea88 on 06 Jul 2020 00:13:20

RE: Support creating calculation groups in Power BI Desktop

This function would help a lot all kind of measures like budget deviation forecast deviation i financial reporting. It would save us a lot of measures

02d912eb 01cd-49db-bbf5-7c8fd34a8fc2 on 06 Jul 2020 00:10:55

RE: Support creating calculation groups in Power BI Desktop

looks like we are getting this via XMLA endpoints which will allow 3rd party tool connectivity for tabular editor which will allow you to create calculation groups (also the new Enhanced Metadata preview feature). Exciting! This also solved the not being able to graph custom formatted numbers!

fe1ddeed 7b83-408b-8100-21249ea521ca on 06 Jul 2020 00:10:52

RE: Support creating calculation groups in Power BI Desktop

This would be great to use in combination with matrix tables. Would be great if it could be implemented soon!

b64fd4ff d765-43d3-b225-3b15c97116f1 on 06 Jul 2020 00:10:40

RE: Support creating calculation groups in Power BI Desktop

This is very useful in Financial reporting for reporting Profit & Loss Budget versus Actual and time dimention YTD LYD