Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
33 | |
16 | |
13 | |
10 | |
8 |
User | Count |
---|---|
59 | |
20 | |
12 | |
11 | |
10 |