Reply
avatar user
Anonymous
Not applicable
Partially syndicated - Outbound

Calculated rows in a table

Hi , I need to build a matrix table with a couple of dimensions on it. This is the structure of the table :

table.png

 

I know that I can get line 3 with a dimension that groups lines 1 and 2 (same with line 6). But what about line 7 (which is the result of line 3 - line 6) ?

 

So my goal is to have a couple of calculated subtotals that sometimes grab different lines from the report. Which is the best way to achieve this?

 

Thanks

1 REPLY 1
V-pazhen-msft
Community Support
Community Support

Syndicated - Outbound

@Anonymous 

Are you working with power bi? I don't really understand how you are calculating using DAX.

Can you provide a sample table of what you have now, and then provide another expected output table?

 

Regards
Paul

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)