Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hi i am new Power BI Please help me ,Country-wise Max, Min & Avg price with all type of product parameter filtrations option
| Product | Country | Rate in per Kg) |
| HOSO | United Arab Emirates | 15.00 |
| HOSO | United Arab Emirates | 4.00 |
| HOSO | United Arab Emirates | 3.00 |
| HOSO | United Arab Emirates | 16.00 |
| PD | United States | 26.00 |
| PD | United States | 3.00 |
| PD | United Kingdom | 7.00 |
| PD | United Kingdom | 9.00 |
| PD | United Kingdom | 15.00 |
Just recreated your data:
Now define simple measures:
Minimum = MINX(Data, Data[rate per kg])
Maximum = MAXX(Data, Data[rate per kg])
Average = AVERAGEX(Data,Data[rate per kg])
For a bit more inside, use matrix visual, put country as columns, products as rows, the 3 measures as values, here you are:
Feel free to convert all numbers as currency, looks better.
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 14 | |
| 7 | |
| 4 | |
| 4 | |
| 3 |
| User | Count |
|---|---|
| 23 | |
| 10 | |
| 10 | |
| 6 | |
| 5 |