Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

calculated column to filter based on another column

Hi, I am making a control chart, stdev is based on "d2n" atm . I have two tables, both are related by "wrk_cde" of datatype text,   I have created a measure that converts dates to numbers starting...
Need Help
Show and Tell
Sahir_Maharaj's avatar
Sahir_Maharaj
Icon for Super User rankSuper User
2 years ago

Hello Anonymous,

 

Can you please try this:

Filtered d2n Sum = 
SUMX(
    RELATEDTABLE(Table2),
    Table2[d2n]
)

Also note that calculated columns are not context-aware in the same way measures are. They are calculated at the time of data refresh and do not change based on slicer selections. So, a calculated column may not be suitable for your requirement if you need dynamic behavior based on slicer selection.

 

Should you have any questions, please do not hesitate to reach out to me.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hello Sahir_Maharaj 

 

I forgot to mention "d2n" is in Table 1 and "wrk_nm" is in Table 2,

I have tried creating a measure but the x-axis for a line chart does not accept measures. 

how shall I proceed with this?