Question

Fixing the Level of Details (LOD) of a Measure

  • 2 November 2021
  • 1 reply
  • 46 views

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? 


1 reply

Hey Ahmed,

I have the same challange and stepped over the feature symmetric aggregates but have not tried it yet.

Let me know if it does the job for you. Im curious. Cheers

Reply