Reply
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

Anonymous
Not applicable
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Calculated rows in a table
09-23-2020
11:30 AM
Hi , I need to build a matrix table with a couple of dimensions on it. This is the structure of the table :
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-25-2020
12:32 AM

@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

Helpful resources
Recommendations
Subject | Author | Posted | |
---|---|---|---|
04-22-2024 12:18 PM | |||
03-14-2024 04:54 AM | |||
04-15-2024 09:17 AM | |||
04-18-2024 12:55 PM | |||
10-10-2023 12:52 AM |
Featured Topics
Top Kudoed Authors (Last Month)
User | Count |
---|---|
141 | |
112 | |
83 | |
63 | |
47 |