Forum Discussion

sf_'s avatar
sf_
Frequent Visitor
9 years ago
Solved

create a calculated column while ignoring row context

Dear community    I'm having an issue with Power BI (desktop). Here's a small example to illustrate:    I have two Tables, A and B. Table A consists of two columns: code and product. Each code an...
Need Help
  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    Hi sf_,

     

    Not like measures, calculate columns are computed during the database processing(e.g. data refresh) and then stored in the model, they do not response to user selections on the report. So I don't think this can be done with a calculate column in this case.:smileyhappy:

     

    Regards

sf_'s avatar
sf_
Frequent Visitor
9 years ago

Dear v-ljerr-msft

 

Thank you for the suggestion! This indeed works fine as a measure -- I managed to create a similar one with the same result --- but the problem is that I need a calculated column. Unfortunately, this does not work as a column:

 

 

Any ideas how to resolve that?

 

Best wishes and thank you again for your help!

v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
9 years ago

Hi sf_,

 

Not like measures, calculate columns are computed during the database processing(e.g. data refresh) and then stored in the model, they do not response to user selections on the report. So I don't think this can be done with a calculate column in this case.:smileyhappy:

 

Regards