Forum Discussion
Solved
remove lines from table
Hello everyone; I created a new table from another table by the function SUMMURIZE. The new table created contains empty fields; My question: how can i remove the lines that contain empty fields f...
Wrap your Table parameter with a FILTER.
Table = SUMMARIZE(FILTER(Customers,Customers[Segment]="Segment2"),Customers[Segment],"Sum ID",SUM(Customers[CustomerID]))
Only returns Customers in "Segment2".
Wrap your Table parameter with a FILTER.
Table = SUMMARIZE(FILTER(Customers,Customers[Segment]="Segment2"),Customers[Segment],"Sum ID",SUM(Customers[CustomerID]))
Only returns Customers in "Segment2".
Greg_DecklerThank's a lot Friend :womanhappy: