Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
User | Count |
---|---|
42 | |
28 | |
23 | |
18 | |
15 |
User | Count |
---|---|
54 | |
35 | |
18 | |
17 | |
15 |