removing data from a cell

[Anonymous]

How do I remove data from a cell?

I want to determine the percentage of each response option for Question 1, but I do not want two of the response options calculated in the percentage/total. I know if I create a measure using Calculate, it will automatically ignore blanks, so I would like to remove the data from the cells so the measure reads it as blank. When I unselect them while editing, it removes the whole row. I just want the data in the cell to be blank. 

Thanks 

[v-yulgu-msft]

Hi @Anonymous,

As AlexisOlson suggested, you need to filter out those two rows by adding a filter context in measure calculation. For more advice, please post sample data and show us expected result.

Regards,

Yuliana Gu

[AlexisOlson]

Rather than editing your data, I would recommend writing your measure to exclude the rows you don't want to look at.

CALCULATE(
    <% or Total Calc Here>,
    TableName[Response Option] <> "Response to Ignore #1",
    TableName[Response Option] <> "Response to Ignore #2"
)