Skip to main content

Power BI

Completed

Support creating calculation groups in Power BI Desktop

Vote (3506) Share
Marco Russo's profile image

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.

Zoe Douglas (administrator) on 22 Nov 2023 16:53:24

Released for public preview with Model Explorer in October 2023. https://learn.microsoft.com/power-bi/transform-model/calculation-groups

Comments (44)
Marco Russo's profile image Profile Picture

Paul Osuldsen 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

Marco Russo's profile image Profile Picture

Adam Gilmore on 06 Jul 2020 00:10:37

RE: Support creating calculation groups in Power BI Desktop

Our requirement is to filter a fact table by one of 15 calendar relationships (through USERELATIONSHIP), and one of 5 currencies depending on the user's selection, or a default if they don't select a Calendar or a Currency.

It's almost impossible to achieve without this feature.

Marco Russo's profile image Profile Picture

lewis hamilton on 06 Jul 2020 00:09:22

RE: Support creating calculation groups in Power BI Desktop

'The comment preceding each DAX expression identifies the corresponding calculation item:

-- Calculation Item: YTD
--
CALCULATE (
SELECTEDMEASURE () ,
DATESYTD ( 'Date'[Date] )
)

--
-- Calculation Item: QTD
--
CALCULATE (
SELECTEDMEASURE () ,
DATESQTD ( 'Date'[Date] )
)

--
-- Calculation Item: SPLY
--
CALCULATE (
SELECTEDMEASURE () ,
SAMEPERIODLASTYEAR ( 'Date'[Date] )
)

Marco Russo's profile image Profile Picture

David Cresp on 06 Jul 2020 00:08:26

RE: Support creating calculation groups in Power BI Desktop

This is really needed and would help performance in a dashboard that I am working on a lot. Please bring this sooner rather than later.

Marco Russo's profile image Profile Picture

Umar Ayub on 06 Jul 2020 00:07:44

RE: Support creating calculation groups in Power BI Desktop

Hi it would be great to have this functionality when connected to a Tabular model. We've got quite a few financial reports that require custom groupings due to different focus areas for different business units. Pushing all of this report specific logic into the model just makes us less agile. We've been relying on uncertified Power BI grid (financial matrix) controls from Market place to get around this.

Marco Russo's profile image Profile Picture

Power BI User on 06 Jul 2020 00:06:25

RE: Support creating calculation groups in Power BI Desktop

This is absolutely vital and needed. Otherwise, it becomes obsolete for most of us since the costs are way too high. good concept of re-usability in PowerBI, I support Marco's Suggestion of implementing this in PowerBI update earlier than scheduled.

xoxo
Goodmann for
https://führerschein-online-kaufen.com/personalausweis-falschen-kaufen

Marco Russo's profile image Profile Picture

Mike on 06 Jul 2020 00:05:48

RE: Support creating calculation groups in Power BI Desktop

This would be great I hope especially for performance

Marco Russo's profile image Profile Picture

Power BI User on 06 Jul 2020 00:04:57

RE: Support creating calculation groups in Power BI Desktop

This would save tons of time!

Marco Russo's profile image Profile Picture

Mohamed CHELLY on 06 Jul 2020 00:04:33

RE: Support creating calculation groups in Power BI Desktop

Very important feature!

Marco Russo's profile image Profile Picture

Dr John on 06 Jul 2020 00:04:06

RE: Support creating calculation groups in Power BI Desktop

We need Calculation Groups, especially in Power BI Premium