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
Mariusz's avatar
Mariusz
Icon for Community Champion rankCommunity Champion
6 years ago

Hi Anonymous 

 

If you place all these columns in a table visual it will apply group by as default, have you tried that?

 

 
Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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, 

    ADexibleDMF             1,688.00
    ADNonexibleDMF             1,107.00

     

    The Expected result is below :

    ProelemtidTotal
    ADexible77LL276
    Chiexible77LL138
    Adexible9MA205
    ADexibleDMF             1,688.00
    ADNonexibleDMF             1,107.00
    AdxibleFGY699
    AdxibleFGY699
    dentNonexibleTHN219

     

    Please see attached powerBI file with sample data 

    powerBI file attached 

    I hope this explanation helps

    • v-yuta-msft's avatar
      v-yuta-msft
      Icon for Community Support rankCommunity Support
      6 years ago

      Anonymous ,

       

      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