Fixing the Level of Details (LOD) of a Measure

Ahmed4
New Member

We have the following hierarchy:

  1. Orders
  2. Shipments
  3. Items

Orders include one or more shipments, shipments include one or more items, and each item might be ordered with different quantities. 

We have created a measure to show the revenue in items level. However, I need to show the revenue of the item level AND the order level within the same look. I don’t want to build another derived table because I need to replicate this a lot for some other dimensions as well.

Any idea? 

0 1 1,264
1 REPLY 1
Top Labels in this Space
Top Solution Authors