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.
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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
70 | |
36 | |
21 | |
18 | |
15 |
User | Count |
---|---|
126 | |
30 | |
28 | |
24 | |
22 |