Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Creating a Summary Table - Consolidating Multiple Lines With More Than One Unique Data Element

I have a report that shows all the lines associated with an order number. The problem is that in a few select cases the multiple lines of an order will contain a two or more unique "Line Category". B...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Anonymous ,

    I have created a simple smaple, please refer to it to see if it helps you.

    Create a measure.

    Measure = CALCULATE(DISTINCTCOUNT('Table'[line hcart]),FILTER(ALL('Table'),'Table'[Order]=SELECTEDVALUE('Table'[Order])))

    Then create the table.

    Table 2 = 
 SUMMARIZE('Table','Table'[Order],'Table'[line hcart],"aaa",SWITCH(TRUE(),[Measure]=1,'Table'[line hcart],"Mult"))

     

    How to Get Your Question Answered Quickly 

     

    If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

     

    Best Regards
    Community Support Team _ Polly

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Padycosmos 

 

I am familiar with the summarize function, but what I don't know how to do is create the "Final Category" column that looks at all the lines associated with a single order number and generates "Multi" if there are more than one distinct text values in the "Line Category".