Forum Discussion

vanik85's avatar
vanik85
Helper I
2 years ago

Using 2 different measures in Calculation Groups

Hi 

 

I have 3-4 tables where Revenue and Order Quantity is available. Wanted to understand if I can create a calculation group to find Avg Ticket Size and apply to all the tables without  creating individual measure using different table.

 

e.g

Table 1 has Order Value and Order Quantity 

Table 2 has Revenue and Units Sold 

table 3 has Sales and Items Sold 

 

Currently  I create Avg ticket size using Order Value / Order Quality similarly Revenue / Units sold individually in each table and wanted a simple calculation group applicable to all tables where there are 2 selected measures one picks values from order value and other Order quantity or Reveue is stored in one selected measure and Unit sold in another measure dynamically these giving me division of selected measure 1 / Selected measure 2