Forum Discussion

milomilo2020's avatar
milomilo2020
Frequent Visitor
4 years ago
Solved

Calculated column filtered by Date from another table

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

1 Reply