Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I created a table to show the margin we are making per lb by item number):
When I use a different category than Item, I get an incorrect value:
I would like the Modifier to average the items in that category and figure out the average "margin per pound" for all items in that category.
My formula for Margin per lb is:
Any insights or help would be appreciated.
Thanks
Solved! Go to Solution.
Hi @joshs444
not sure modifier is from which table therefore the most general formula would be
Average Margin Per lb =
AVERAGEX (
VALUES ( 'Sales by Item'[Item Code] ),
CALCULATE (
DIVIDE (
DIVIDE ( [Sum Margin], SUM ( 'Sales by Item'[QTY] ) ),
SUM ( 'Item List'[Weight pe Case] ),
0
),
CROSSFILTER ( 'Sales by Item'[Item Code], 'Item Listm'[Item Code], BOTH )
)
)
Hi @joshs444
not sure modifier is from which table therefore the most general formula would be
Average Margin Per lb =
AVERAGEX (
VALUES ( 'Sales by Item'[Item Code] ),
CALCULATE (
DIVIDE (
DIVIDE ( [Sum Margin], SUM ( 'Sales by Item'[QTY] ) ),
SUM ( 'Item List'[Weight pe Case] ),
0
),
CROSSFILTER ( 'Sales by Item'[Item Code], 'Item Listm'[Item Code], BOTH )
)
)
User | Count |
---|---|
42 | |
28 | |
24 | |
20 | |
16 |
User | Count |
---|---|
54 | |
35 | |
18 | |
18 | |
15 |