In Power BI, solutions for measures such as smallest aggregates and largest aggregates like total sales, average sales within region, and count distinct values can be performed using DAX measures in addition to the embedded Power BI aggregation functionalities.
Creation of Aggregation Measures: On your Power BI report level, click on the tab called Modeling found at the top part of the window, and then click on New Measure. Code
This part has DAX functions:
Total Sales: Total Sales = SUM('Sales Table'[Sales Amount])
Average Sales per Region: Average Sales per Region = AVERAGE('Sales Table'[Sales Amount])
Count Distinct Values: Unique Regions = DISTINCTCOUNT('Sales Table'[Region])
Integrating Aggregates in the Visuals: When these measures are ready, include them in your visualizations, such as tables, charts, and so on. Power BI will calculate and distribute the values around the table's context, e.g., region or category.
Handling a Collection of Aggregations: To manage and organize many aggregations, you should create a folder in the Fields pane or simply tag your measures with clear phrases, e.g., "Sales—Total" or "Sales—Average." This aids in faster recognition and application in your reports.
The use of these DAX measures also comes in handy and simplifies the process of performing and controlling multiple aggregations in your Power BI tables.
