Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Calculated Column Based on Unrelated, Filtered Table

Currently, I have 2 tables : SalesTable and FilterTable. SalesTable is my main data table with 20+ fields, which includes columns called "Price with Tax" and "Price without Tax". FilterTable only con...
  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    Hi Anonymous,

     

    As Greg_Deckler has mentioned above, not like measures, calculate columns/tables are computed during database processing(e.g. data load/refresh) and then stored in the model, they do not response to user selections on the report.

     

    So it is not possible to create a calculate column/table that can change dynamically with user selections on the report. Only the measure can work in this scenario. :smileyhappy:

     

    Regards

TomMartens's avatar
TomMartens
Super User
9 years ago

Hey,

 

if you need the RowLevel of your 'SalesTable', you have to use MAXX() one of the table iterator functions, like

 

 

MAXX('SalesTable', 'SalesTable'[Price with Tax])

or
MAXX('SalesTable', 'SalesTable'[Price without Tax])

Depending on your TRUE / FALSE branch in your IF statements

 

Hope this helps