Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Continued Contributor
Continued Contributor

Paginated report measure groups

Hello, as I continue down my trail of learning/implementing paginated reports - I would like to organize the groups by like kind measures (expressions)


In this example, I have Years, then 3 differing measures.    I would like to have have the same measure as a top group, and then years as second tier.   Below is a screenshot of what I have in Paginated.


This second screenshot is desired result (as formated in excel)



In PBI, I would use a calculation group, with each measure defined as a item..   However, I have not been successful in that attempt?    Do calculation groups work within PAginated?


Or other workarounds?   I appreciate any thoughts or links that might be of value.

thank you! 



Continued Contributor
Continued Contributor

Hello, to hopefully clarify my original request.    Here's an example of using calculation groups w/PBI to group measures by year.    I am hoping to have a similar report w/Paginated.  But, as in above example - I don't quite have yet.


Greatly appreciate if someone has thoughts or provide a thought on how to proceed.   I am unable to make calculation groups work inside SSRS. 


Also, please advise if there are alternative forums to post paginated questions.  I know, I am not quite in the right space. 

thank you!

Helpful resources

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.