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.
Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.
User | Count |
---|---|
103 | |
67 | |
45 | |
43 | |
35 |
User | Count |
---|---|
100 | |
58 | |
52 | |
45 | |
40 |