Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have a report I'm trying to create where there are mixed units of measurement based on which product is shipped.
Some of our products have a measurement of Gallons, some Lbs, and some Each. I have a table relating product, size, unit of measure, and conversion from each shipped to the associated unit of measure. I created a calculated column on the sales table "Shipped UOM = [Shipped Qty] * RELATED('Product UOM'[UOM per Piece])". I would like graphics to display 50 Gallons or 2 Lbs instead of 50 or 2 (depending on the product measurement unit).
Subset of Sales Table
Relationships in the Model
Read about Calculation Groups and the formatting options there.