Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Hi @vanik85 ,
You can refer to the following documentation that describes in detail how to create calculation groups.
Create calculation groups in Power BI (preview) - Power BI | Microsoft Learn
Then please provide some screenshot information and describe your requirement so that I can answer your question as soon as possible.
Best Regards,
Adamk Kong
User | Count |
---|---|
100 | |
87 | |
81 | |
76 | |
71 |
User | Count |
---|---|
113 | |
104 | |
100 | |
73 | |
65 |