Forum Discussion
Distinct Orderid group by profile
If you take Idorder FGY for example, I have two different id's c475 and 481e with same element.What I want is distintc ids and group by pro in the expected out below: Sample Data ids Price ...
Mariusz if i drag the columns in a Table visual, It is not giving me what I want 100%, please see below the result when I put all these columns in a table visual:
If you take ID: "DMF for example has 12 rows, 2 disticnt elemt (exible and non exible),6 unique ids but belong same pro categories, if you remove the duplicated ids, the result should be as below for DMF,
| AD | exible | DMF | 1,688.00 |
| AD | Nonexible | DMF | 1,107.00 |
The Expected result is below :
| Pro | elemt | id | Total |
| AD | exible | 77LL | 276 |
| Chi | exible | 77LL | 138 |
| Ad | exible | 9MA | 205 |
| AD | exible | DMF | 1,688.00 |
| AD | Nonexible | DMF | 1,107.00 |
| Ad | xible | FGY | 699 |
| Ad | xible | FGY | 699 |
| dent | Nonexible | THN | 219 |
Please see attached powerBI file with sample data
powerBI file attached
I hope this explanation helps
v-yuta-msft
Community Support
Community SupportAnonymous ,
Could you please clarify the step of “remove the duplicated ids” and show the logic of achieving 1,688.00 and 1,107.00?
Regards,
Jimmy Tao