Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi everyone
I have a report in direct query.
Consider I have 2 tables(table1 and table2) which both have a column that contains stock items. The relation is one to many.
how can I calculate Table1[Qty]*Table2[Price] for each Stock item? (I did it by creating a measure but when I use Card, the filters doesn't apply on it , but in a table, it works perfect)
Solved! Go to Solution.
@Matt_Gol , As suggested by @Luuky Try SUMX with related. If there is 1-M relationship between Table 2 to table 1 it should work
example
Sumx(Table1, Table1[Qty]*related(Table2[Price]))
if not then you might have do more work
example
Sumx(Table1, Table1[Qty]*Maxx(filter(Table2, Table[Item] = Table2[Item]) , Table2[Price]))
you can more conditions in second one as per need
@Matt_Gol , As suggested by @Luuky Try SUMX with related. If there is 1-M relationship between Table 2 to table 1 it should work
example
Sumx(Table1, Table1[Qty]*related(Table2[Price]))
if not then you might have do more work
example
Sumx(Table1, Table1[Qty]*Maxx(filter(Table2, Table[Item] = Table2[Item]) , Table2[Price]))
you can more conditions in second one as per need
Hi @Matt_Gol ,
Try Sumx for it in a measure. If thats not working then I need some visualisation of the tables and how they are related.
Greetings,
Luuk
User | Count |
---|---|
132 | |
74 | |
70 | |
58 | |
54 |
User | Count |
---|---|
192 | |
96 | |
67 | |
64 | |
54 |