Forum Discussion

David_1970's avatar
David_1970
Frequent Visitor
8 years ago
Solved

Creating measure

  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 20170...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 years ago

    Hi,

     

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

  • Phil_Seamark's avatar
    Phil_Seamark
    8 years ago

    Hi David_1970

     

    Please try this calculated table

     

    NewTableName = 
        FILTER(Table1,
		'Table1'[Revenue]<> BLANK()
		)
  • v-huizhn-msft's avatar
    v-huizhn-msft
    8 years ago

    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

CahabaData's avatar
CahabaData
Memorable Member
8 years ago

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

                )