Creating measure

[David_1970]

How do I return a table excluding all rows where [Revenue] is blank, see example below. Which DAX function?

Customer	Revenue	Disbursement	DateMonth
1	156		201701
2	365	18	201702
3		32	201703
3		69	201704
2	152	54	201705
5	325	21	201706
4	145	69	201707
2	262	58	201708
3		45	201709
6	326	52	201710
1	52		201711
1	123		201712

[Ashish_Mathur · Accepted solution]

Hi,

This can be done without a DAX formula.  In Power Query, one can simply filter the revenue column on >0.

[Phil_Seamark · Accepted solution]

Hi @David_1970

Please try this calculated table

NewTableName = 
        FILTER(Table1,
		'Table1'[Revenue]<> BLANK()
		)

[v-huizhn-msft · Accepted solution]

Hi @David_1970,

As I tested, the formula @Phil_Seamark posted is right. Please click "New Table" under modeling on Home page(highlighted in yellow background), type the formula, you will get expected result. 

Table = FILTER(Table1,Table1[Revenue]<>BLANK())

Best Regards,
Angelia

[Phil_Seamark · Accepted solution]

Hi @David_1970

Please try this calculated table

NewTableName = 
        FILTER(Table1,
		'Table1'[Revenue]<> BLANK()
		)

[Ashish_Mathur · Accepted solution]

Hi,

This can be done without a DAX formula.  In Power Query, one can simply filter the revenue column on >0.

[CahabaData]

NewTableName = SUMMARIZE(
        FILTER(Table1,'Table1'[Field1]<> BLANK()),
            'Table1'[Field1],
            ‘Table1’[Field2]
             etc.

                )