- 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
Multiply values in columns (Different tables)
Say I have one table like this:
a | 1,02 |
b | -0,4 |
c | -5 |
a | -3,2 |
b | 3 |
c | -4,5 |
And the other table like this:
a | 839403284 |
b | 932848032 |
c | 39842048 |
How to I multiply each of the values in the first table with the corresponding values in the second table?
And what should the relation on the "Model"-page look like?
Thanks!
Solved! Go to Solution.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @sigridr ,
Please refer to my pbix file to see if it helps you.
Create a measure.
Measure = MAX('Table'[value])*MAX('Table (2)'[val])
If I have misunderstood your meaning, please provide more details with your desired output.
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @sigridr ,
Please refer to my pbix file to see if it helps you.
Create a measure.
Measure = MAX('Table'[value])*MAX('Table (2)'[val])
If I have misunderstood your meaning, please provide more details with your desired output.
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @sigridr
My Undestanding that you cannot create calculated columns and you cannot create or edit relationships. Then try to create New Measure
NewMeasure =
SUMX (
Table1,
VAR Name = Table1[Name]
VAR Value1 = Table1[Value]
VAR Value2 =
MAXX ( FILTER ( Table2, Table2[Name] = Name ), Table2[Value] )
RETURN
Value1 * Value2
)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello, in the idea you provided, what is the "name"? i understand what table and values are but i dont understand whats supposed to go where is says name
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
This worked perfectly for me thank you very much!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
This works for most categories:
But for certain others it's completely wrong... why would that be?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
unrelated, but this solved a problem I was stuck in for days. thank you.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
can you share a picture of the diagram view showing the relationship between the tables ?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
It's a simple, many-to-one relationship.
One table has only one occurence of each value, while the other table has lots of occurences of each value. Does it matter wheter it's formatted as numbers or text? (the values that are related are 4-number values)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
It doesn't matter whether they are numbers or text but they both need to be the same. and if its text you need to make sure that there are no leading or trailing spaces in either column, as that would throw the relationship out
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
All of that should be in order.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Firstly you can create a relationship between the two tables based on the common column. Now you can use the below DAX to do the multiplication -
Multilple = TABLE1[COLUMN1]* RELATED(TABLE2[COLUMN2])
Let me know this helped you.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
It won't let me chose the right columns.. 😞
What should I do?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Create a relationship between the two tables first.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
That should be in order, but there are still some of the calculations that are completely wrong..
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Firstly you can create a relationship between the two tables based on the common column. Now you can use the below DAX to do the multiplication -
Multiply = TABLE1[COLUMN1]* RELATED(TABLE2[COLUMN2])
Let me know if this helped you.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
If you know that there will only be 1 entry per item in the 2nd table then you can create a one-to-many relationship between the tables. You would then be able to use the RELATED function to do the multiplication. e.g. you could create a column on the first table like
Multiplied value = 'Table 1'[Value] * RELATED('Table 2'[Value])
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
It won't let me make that formula.. 😕

Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Microsoft Fabric Community Conference 2025
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

Subject | Author | Posted | |
---|---|---|---|
06-06-2024 04:39 AM | |||
05-21-2024 08:34 AM | |||
05-11-2023 03:36 AM | |||
04-16-2024 02:23 AM | |||
02-07-2023 12:55 PM |
User | Count |
---|---|
21 | |
18 | |
17 | |
7 | |
5 |
User | Count |
---|---|
32 | |
27 | |
19 | |
13 | |
12 |