Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello,
I have the following situation:
Table1:
Material | Qty |
SB340 | 800 |
Table2:
Components | Lvl Above |
SB340 | SB330 |
SB330 |
I want to create a measure that shows 800 associated to the components SB330.
the two tables do not have reletionship due to additional complexities of the model.
regards
Solved! Go to Solution.
Ok, I think I got it:
I broke it up in two measure:
M1=CALCULATE(SUM(table1[Qty]),Table1[Material] IN VALUES(Tabl2[Components]))
M2 =CALCULATE(M1,ALL(Table2),Table2[Lvl Above] IN VALUES(Table1[Components]))
Ok, I think I got it:
I broke it up in two measure:
M1=CALCULATE(SUM(table1[Qty]),Table1[Material] IN VALUES(Tabl2[Components]))
M2 =CALCULATE(M1,ALL(Table2),Table2[Lvl Above] IN VALUES(Table1[Components]))
Hi, can you have inactive relationship between the two? Just create the relationship, but it shall be inactive.
Then you can write a formula:
Qty=
User | Count |
---|---|
25 | |
12 | |
8 | |
6 | |
6 |
User | Count |
---|---|
26 | |
12 | |
11 | |
8 | |
6 |