How to generate a new table base on some conditions
Hi team, Good day, I got a problem which need your kind advice, thanks in advance. I have a table1 in Power BI, the data is as following: Now I want to create another table (table2) base on table1, but only select few data base on conditions 1 & 2: 1. Only select these 4 columns data: GEOGRAPHY.03 MARKET, FISCAL TIME.04 FISCAL MONTH, PRODUCT LINE, AMT 2. Only the sum of AMT for GEOGRAPHY.02 SUPER REGION is not 0 should show in this table2 so this means only row 9-13 meet this condition, because row 1-8 sum AMT for SUPER REGION Asia Pacific is 0, although row 13 contains 0, but sum of AMT for Americas is not 0. So finally I would like to generate the table 2 like following:
