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.
I want to multiple one column table with one of my measure
In my Measure I do Quantity * Unit Price and these column are in same table
I do Average, MIN, and MAX but its giving me wrong answer
Table A |
12 |
3 |
4 |
5 |
6 |
14 |
7 |
Table B |
3 |
14 |
15 |
2 |
5 |
8 |
5 |
Solved! Go to Solution.
@abc_777 , When you do the product of two numbers, you need to do it at row level or some common group level.
You need use values or summarize from same column
Tab has [Column] common from A and B Joined on column
example
sumx( values(Tab[Column]), calculate(Sum(TableA[Value]) * Sum(TableB[Value])))
@abc_777 , When you do the product of two numbers, you need to do it at row level or some common group level.
You need use values or summarize from same column
Tab has [Column] common from A and B Joined on column
example
sumx( values(Tab[Column]), calculate(Sum(TableA[Value]) * Sum(TableB[Value])))
thanks amit, actually i had relation or data modeling issue. Fixed it. thank you so much. I also keep this calculation in my note.
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 |
---|---|
114 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |