Forum Discussion

MKEHawkeye's avatar
MKEHawkeye
Frequent Visitor
8 years ago

DAX - Can a Calculated Column Ignore Row Context and Keep Table Filter Context?

Is it possible for a DAX Calculated Column to keep table filter context but ignore row filter context? I have tried every combination of CALCULATE, EARLIER, and ALL, ALLEXCEPT, ALLSELECTED to no avai...
Need Help
Vvelarde's avatar
Vvelarde
Community Champion
8 years ago

 

This is not what you expected?

 

Is you want to this column will be dynamic, that's not possible. The calculated columns are "calculated" when the model is loading. Not change with filters or slicers in the report visual.

 

Regards

Victor

MKEHawkeye's avatar
MKEHawkeye
Frequent Visitor
8 years ago

Filter Key to keep only the top 2 rows. Does the result change?

  • Vvelarde's avatar
    Vvelarde
    Community Champion
    8 years ago

    MKEHawkeye

     

    Review my previous answer.

    • MKEHawkeye's avatar
      MKEHawkeye
      Frequent Visitor
      8 years ago

      Vvelarde Sorry, missed the bottom portion of your post. Thank you for confirming it's not possible. Best regards!