Reply
asparagus1_
Frequent Visitor

Using multiple calculation groups at the same time

I have a parameter table that allows me to change the measure currently displayed in the report table. Additionally, I have a calculated group that I can change to show the measure in different contexts like YTD, SPLY, and other options. Is there a way to display the same measure in several different contexts, such as measure 1 YTD and measure 2 YTD, while retaining the table visualization and my parameter table? Something like this: 

FA928D12-5D47-4422-B85A-F1E68407BF58.png

The problem which I have is that when I use column from param table and put it on table visual I can only select one calculation group item at the same time. I know I could choose matrix visual and put calculation group items on columns but I need to stick to table visual.

thanks! 

2 REPLIES 2
amitchandak
Super User
Super User

@asparagus1_ , I have used multiple in Matrix visual

 

calculation group authoring| Measure Slicer: https://youtu.be/VfxfJJ0RzvU

 

Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Thank you for answering. Yes, i know it's possible with matrix but I would like to stick to table visual. I am looking for some workaround or confirmation that is not possible.

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

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

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)