Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

removing data from a cell

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 

Need Help

2 Replies

  • AlexisOlson's avatar
    AlexisOlson
    Super User
    7 years ago

    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"
)
  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    7 years ago

    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