Forum Discussion

julianst24's avatar
julianst24
Frequent Visitor
4 years ago

Help with a filtered summarized table

Hi there, i have a question, whats the optimal way to convert this dax:

 

ESS1 = SUMMARIZE(sdms_st_so,sdms_st_so[ESS1 CLEAN],sdms_st_so[OFFERING ESS1],sdms_st_so[bg],sdms_st_so[segment],sdms_st_so[sug_segment],sdms_st_so[country_code],sdms_st_so[sales_org],sdms_st_so[sales_office],sdms_st_so[fiscal_qtr_year],sdms_st_so[invoice_no],sdms_st_so[invoice_date],sdms_st_so[seller_crm_id]...)
 
into a table that only has the values when ESS1 CLEAN is not BLANK.
In resume, to filter all the blanks in ESS1 CLEAN when creating the summarized table.
 
Thanks!
 

 

Need Help
Tips and Tricks

1 Reply

  • Hariharan_R's avatar
    Hariharan_R
    Solution Sage
    4 years ago

    Hi,

    If you need additional table using DAX with all the columns from same table and want to filter only not blank rows then check the below options.

     

    1. if blank records are not used anywhere then filter in database or power query layer itself

    2. if you blank values for other calculations and only this DAX table should not be blank then you can use FILTER.

     

    New Table = FILTER('Table', 'Table'[Type]<> BLANK())   
     
    Replace 'Table' with your table name.
    Thanks
    Hari
    Did I answer your question? Then please mark my post as the solution.
    If I helped you, click on the Thumbs Up to give Kudos.

    My Blog :: YouTube Channel :: My Linkedin