Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Community,
Having not much experience with DAX I am having trouble with the following;
Below are my sample tables, their relationships and the values
I would like to be able to multiply the "Raw Data" in the data table by the "Weightings" in the weightings table.
Should this be a measure or calculated column?
Do I need to create an additional table in modeling to do this?
Any help would be much appreciated!!
Solved! Go to Solution.
Hi @Anonymous ,
I dont think you need any additional table.
There is already a relationships between these two tables.
You can use either a quick measure , measure or calculated column for this :
1. Quick Measure
2. DAX measure
Measure = Sumx('Data Table','Data Table'[Raw Data]*related(weightings[weightings]))
3. calculated column
Column = 'Data Table'[Raw Data]*RELATED(weightings[weightings])
the answers is going to be the same.
Look at my output.
let me know for any question.
Thanks,
Tejaswi
Hi @Anonymous ,
I dont think you need any additional table.
There is already a relationships between these two tables.
You can use either a quick measure , measure or calculated column for this :
1. Quick Measure
2. DAX measure
Measure = Sumx('Data Table','Data Table'[Raw Data]*related(weightings[weightings]))
3. calculated column
Column = 'Data Table'[Raw Data]*RELATED(weightings[weightings])
the answers is going to be the same.
Look at my output.
let me know for any question.
Thanks,
Tejaswi
@Anonymous
This works as I need thanks!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
88 | |
63 |