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 ...
v-yuta-msft ad and AD are in the same pro column was just a typo with caps
Measure =
VAR SumTrip = SUMMARIZE('Table (2)','Table (2)'[Elemt],'Table (2)'[ids])
RETURN
SUMX(SumTrip,MAX('Table (2)'[Price]))
The measure above almost gave me what I want but the highlited ID and element measure total is wrong and what I expect is :
| AD | exible | DMF | 1,688.00 |
| AD | Nonexible | DMF | 1,107.00 |
I need help fixing the measure and I have attached a link to the PowerBI file