How to remove blank rows in the column which is created by DAX?

[Anonymous]

Hi Experts,

I am working on the scenario like creating matrix table and added 3 rows , but in that rows i am having blank values in the column , so it is showing nothing when it expanded as below :

Those blank spces are related to the below tables parameter only .. i cannot remove this blindly because the other data on this tables will also excluded in the matrix . this "tables" was a new column created by using New Column .. so we cannot perform actions from Power Query. Tried with filter pane options (is not blank) but still other fields are affecting 😞

So without impacting other fields how come i fix this ? Sharing the table view and DAX here :

tables = if(DN_Customer[COGS (groups) (groups)] in {"Revenue","COGS","Gross Profit"},DN_Customer[Business Segment L4],if(DN_Customer[COGS (groups) (groups)]="SG&A"&&[Type]<>"Segment SG&A","Enablement Functions Subtotal SG&A",if(DN_Customer[COGS (groups) (groups)]="SG&A"||[Type]="Segment SG&A","Segment SG&A")))

Thanks

DK

[Irwan · Accepted solution]

Hello @Anonymous 

you can filter out those blank value via filter pane.

in this dummy data, column 3 has two blank value which is 2 and 4.

After being filtered out, the value 2 and 4 are gone.

since this is just visual filter, it will not affect any calculation.

if this doesnt solve your problem, perhaps you need to remove those blank value by SUMMARIZE the table.

Hope this will help you.

Thank you.