Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
113 | |
105 | |
95 | |
58 |
User | Count |
---|---|
174 | |
147 | |
136 | |
102 | |
82 |