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)