calculated column to filter based on another column

[sms2000]

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 from 1 "d2n", 

In Table 2 there is a column "wrk_nm" that is of datatype text and I have a slicer based on this 

upon the slicer selection the "d2n" displays all the points and plots the ones that are related to the selection this causes blank connections in the line chart.

I want a measure/ calculated column that returns only the values associated with the slicer selection .

*DSN has different values for each day so the new measure/calculated column cannot just return a single value*

[Sahir_Maharaj]

Hello @sms2000,

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.

[sms2000]

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?