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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
DAX Bring two columns from different tables, and one table has measures
04-21-2023
08:15 AM
Hi,
I am trying to bring two columns from different tables that are connected but one table has only measures, how can I bring it? Or do I need to create the masure in here? Because I am new and is complicated for me to move it, thanks
Solved! Go to Solution.
1 ACCEPTED SOLUTION
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-21-2023
08:31 AM
Because its a measure and not a column you need to give it a name in SUMMARIZECOLUMNS,
EVALUATE
SUMMARIZECOLUMNS (
VALIDATED_PD[m_Group_Currency_Amount],
"Total Overdue", [a_TotalOverdue]
)
3 REPLIES 3
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-21-2023
08:31 AM
Because its a measure and not a column you need to give it a name in SUMMARIZECOLUMNS,
EVALUATE
SUMMARIZECOLUMNS (
VALIDATED_PD[m_Group_Currency_Amount],
"Total Overdue", [a_TotalOverdue]
)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-21-2023
08:38 AM
Thanks it works! is the same logic for calculates columns? Or do I need to create it as a measure?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-21-2023
08:42 AM
You don't need to specify a name for a calculated column, you can just specify the column, but all the columns need to be before the measures in the SUMMARIZECOLUMNS

Helpful resources
Recommendations
Subject | Author | Posted | |
---|---|---|---|
04-15-2024 11:09 AM | |||
03-26-2024 03:14 AM | |||
04-11-2024 01:52 AM | |||
08-14-2024 11:19 AM | |||
05-21-2024 08:34 AM |