Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi everyone,
Sorry, it's a confusing topic, but hear me out.
I have two tables, and one includes an 'Increase %' column, one per each 'Category'.
Say
Category: Fruits
Increase%: 5%
It's connected (one-to-many) with another one.
Second table:
Category: Fruits
Good: Apples
Amount: 100
Basically, I created a sumx(Amount) measure. Then another one for Increase%, but that one is using AVG?
It works fine for the lines (Apples are 100 * 5%), but the total is just wrong. It's calculating the AVG, and it should just add the lines.
Any chance of a solution, please?
Alice
Solved! Go to Solution.
@AliceW ,Create a new column using related on use that in measure
New column in Table 2
New column Increase = related(First[Increase%]) * [Amount])
new measure =
Measure Increase =Sumx(Second, related(First[Increase%]) * [Amount])
Yes, thank you. I went with the column.
The cherry on the cake to solve my matrix problem was to create a MEASURE, Increase = Divide(Amount/Total), and this way a matrix will have the proper totals.
@AliceW ,Create a new column using related on use that in measure
New column in Table 2
New column Increase = related(First[Increase%]) * [Amount])
new measure =
Measure Increase =Sumx(Second, related(First[Increase%]) * [Amount])
User | Count |
---|---|
85 | |
74 | |
71 | |
68 | |
56 |
User | Count |
---|---|
98 | |
96 | |
92 | |
78 | |
70 |