How to Remove a Column Using DAX

[i820017]

Hey Everybody,

I am looking at removing an entire column from a table in Power BI by using DAX

The column that I am trying to remove is highlighted in yellow below.

I know that I can right-click on the column, and exclude the column, but I don't want to do that though (because doing so is not compatible when creating this same Power BI report as a paginated report in the cloud). I want to use DAX to do the same thing. In other words, I want to remove "Channel" = "Agency" and 'type" = "Paperless" by using DAX.

Does anyone know how?

Thanks

Dan 

[amitchandak · Accepted solution]

@i820017 , Create a measure like

calculate(sum(Table[Value]), filter(Table, Table[Channel] = "Agency"  && [type] = "Paperless"))