Forum Discussion
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...
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 _ PollyIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
You may try SWITCH(TRUE(),distinctcount(LineCategory)>1, "Multi",Max(LineCategory),
within the SUMMARIZE()