Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have Table A
Snapshot | ID.1 | ID.2 | Avg Demand |
2/12/2024 | 1 | A | 20 |
2/12/2024 | 2 | A | 30 |
1/12/2024 | 3 | B | 40 |
Table B
Snapshot | ID.1 | LT |
2/12/2024 | 1 | 2 |
2/12/2024 | 2 | 3 |
There is a data connection between table A & B on ID.1
2 Slicers to select the snapshot for Table A & Table B
I have created a Measure to calculate LT* Avg Demand
Now I want to create another measure which do WT LT* Avg Demand i.e., SUM(LT*Avg Demand) instead of SUM(LT)* SUM(Avg Demand) at ID.2 level.
Sort of do first row wise calculation of LT* Avg Demand and then sum it at ID.2 level.
As current measure is doing SUM(LT)*SUM(Avg Demad).
Thanks
Kartik
Solved! Go to Solution.
You can achieve it using SUMX terative function. Assuming your table B is many side of one to many relationship,
Sumx(tableb, related(tablea[Avg Demand]) * tableb[LT])
try the pattern and dont forget to accept my solution if it works.
Tharun
You can achieve it using SUMX terative function. Assuming your table B is many side of one to many relationship,
Sumx(tableb, related(tablea[Avg Demand]) * tableb[LT])
try the pattern and dont forget to accept my solution if it works.
Tharun
User | Count |
---|---|
58 | |
21 | |
18 | |
16 | |
13 |
User | Count |
---|---|
85 | |
54 | |
45 | |
39 | |
21 |