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)

6f6db89a 1751-4dd0-9736-216ab9c6123f 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.

746bf1d7 5e2f-46e5-acb9-0a19a091e333 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] )
)

4e2ed990 e62a-4956-94cf-e2ae7078a9e9 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.

338d2dab 5a09-473d-94bc-c20abc0e1f8c 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.

c10731b5 a56b-4266-bbdb-9cb105866300 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