Calculated column filtered by Date from another table

[milomilo2020]

HI, I have this calculated column in a table:

Calculated column = 

var total_nonbreaches = 
CALCULATE(
    DISTINCTCOUNT(Issues[Key]),
    Issues[Time to first response: Breached?] = "false")

var total_breaches = 
CALCULATE(
    DISTINCTCOUNT(Issues[Key]),
    Issues[Time to first response: Breached?] = "true")

var total = total_breaches+total_nonbreaches 
var final = IF(DIVIDE(total_nonbreaches,total) = 0, 1.00, DIVIDE(total_nonbreaches,total))
 return 

final

The "Issues" table (Fact table) is connected to this table by "Company Code" and also has a "Date" column.

I need to use this "Date" column from "Issues" table to filter the Calculated column when I put it on KPI's.

So my goal is to add this "Date" filter into the DAX, so when I create a KPI with the Calculated column, I can filter by "Date"

Thanks

[amitchandak · Accepted solution]

@milomilo2020 , if you need to join on two-column, then you should create concatenated column both side and join

key  = [Company] & "-" & format([Date], "YYYYMMDD")

But you need move data from one table to another you can use

new column in table 1  example

sumx(filter( Table2 , Table1[company] = table2[Company] && Table1[date] = table2[date] ), Table2[Value])

refer 4 ways to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8