Relationship :

Chandrashekar  Lets's review the set-up first.

1. T2 has a relationship with T1 and values from T2 are used in a slicer to slice T1 values.

2. T2[Date] has an active connection (1-M) T1[SDate].

3. The axis for this report comes from T3 which are neither connected to T1 or T2.

4. The ask is, how can calculation performed on T1 be shown against T3 axis while T2 still slices the calculation.

5. One of the many ways in DAX, TREATAS helps in JOIN for tables that are not in a relationship. SO the solution takes advantage of that.

6. Since you need to show T1[CDate] Count too, an inactive relationship between T2[Date] to T1[CDate] (1 to M) was established. Else, the calculation for _close will not get sliced.

Please find the attached pbix and you need the following measures

_open =
CALCULATE (
    COUNT ( Table1[SDate] ),
    TREATAS (
        SUMMARIZE ( Table3, Table3[Name], Table3[Location] ),
        Table1[Name],
        Table1[Location]
    )
)


_close =
CALCULATE (
    COUNT ( Table1[CDate] ),
    USERELATIONSHIP ( Table2[Date], Table1[CDate] ),
    TREATAS (
        SUMMARIZE ( Table3, Table3[Name], Table3[Location] ),
        Table1[Name],
        Table1[Location]
    )
)

Hello,

I tried to add one more condition to it (Attached Report ) but not getting correct count.