The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
toaHi all,
I'm trying to create a measure which looks at a measure and then multiples it by a value in a table.
Unit Cost (Measure) | Inventory (table) | new measure |
2 | 3 | 6 |
1 | 3 | 3 |
tia
Solved! Go to Solution.
@tripp-r- , You can do that. But for that, you should have a common group by column-like
new measure = sumx(summarize(Item, Item[Item], "_1", [Unit Cost]*[Inventory]),[_1])
Where Item is a common dimension (assumed)
@tripp-r- , You can do that. But for that, you should have a common group by column-like
new measure = sumx(summarize(Item, Item[Item], "_1", [Unit Cost]*[Inventory]),[_1])
Where Item is a common dimension (assumed)
User | Count |
---|---|
15 | |
12 | |
8 | |
7 | |
7 |
User | Count |
---|---|
24 | |
21 | |
12 | |
10 | |
7 |