cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

SSAS Calculation Groups in Report Builder

I'm building reports in Power BI Report Builder using calculation groups (time intelligence) in a live connection to an SSAS Tabular model. Reporting Services is querying SSAS via an MDX query (since DAX has big issues with multi-value parameters). When the report is run, it doesn't seem to constrain the date values - the same calculations work properly in Power BI. I have max & min date measures in the calendar table - the report is displaying the min and max values of the selected date parameters, not the calculations for YTD, MTD, TTM, etc... Has anyone else experienced this?

2 REPLIES 2
Highlighted
Microsoft
Microsoft

Re: SSAS Calculation Groups in Report Builder

There is a little known feature in Report Builder for Multi Value Parameters with DAX. DAX does not natively support MVP's, a placeholder trick was put in the query designer.

 

Untitled.png

 

The button on the far right enables the parameters. It is not a perfect solution, but it does work for most cases. The query will only work when run in a current report server, SSDT or Report Builder.

 
Highlighted
Frequent Visitor

Re: SSAS Calculation Groups in Report Builder

Thanks for the reply. I've known about that feature, but it still doesn't work well with hierarchies and such that I've got going on. Besides, using DAX isn't my issue - the problem is that the calculation groups for time intelligence don't seem to be working.

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

July 2020 Community Highlights

July 2020 Community Highlights

Learn about the exciting things that happened in July.

Featured Data Story of The Month

Featured Data Story of The Month

All Data Stories Gallery contributions are reviewed for each month. We select a contribution and feature the community member the following month.

Power BI Dev Camp - Developing with .NET Core

Power BI Dev Camp - Developing with .NET Core

Learn how to develop custom web applications for Power BI using .NET Core 3.1 and .NET 5.

Power BI Desktop August 2020 Update

Power BI Desktop August 2020 Update

We have great updates this month! Click the link for the video with more info.