Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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 ...
Need Help
v-yuta-msft's avatar
v-yuta-msft
Icon for Community Support rankCommunity Support
6 years ago

Anonymous ,

 

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:

Could you please clarify more details about the logic of grouping by? In addtion, are 'Ad' and 'AD' same in the Pro column?

 

Regards,

Jimmy Tao

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    v-yuta-msft  ad and AD are in the same pro column was just  a typo with caps

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago
      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 :

      ADexibleDMF             1,688.00
      ADNonexibleDMF             1,107.00

       

      I need help fixing the measure and I have attached a link to the PowerBI file

      Pbix file attached 

       

      v-yuta-msft Mariusz