Hi Everyone,
I have below issues in chart..
Consider two fact tables Call Detail and Event Attendee
| call detail |
| call detail id | call name | call status | medical event id | Table_Name |
| 10001 | c_01 | Planned | M01 | Call Detail |
| 10003 | c_02 | Submitted | M02 | Call Detail |
| 10005 | c_03 | Cancelled | M03 | Call Detail |
| 10007 | c_05 | Planned | M07 | Call Detail |
| Event attendee |
| Event attendee id | medical event id | Attendee name | Attendee Status | Table_Name |
| E01 | M01 | aaa | Attended | Event attendee |
| E02 | M05 | ddd | Invited | Event attendee |
| E03 | M06 | ccc | Accepted | Event attendee |
| E05 | M02 | bbb | Accepted | Event attendee |
both the fact table having Key Link fields
for Call detail: AutoNumberHash128([Call Detail ID]&'Call Detail') as [%KeyLinkField]
for Event Attendee: AutoNumberHash128([Event Attendee ID]&'Event Attendee') as [%KeyLinkField]
but we don't have any linkage between Call detail table and Event attendee table. we don't have event attendee id in call detail table we have only medical event id .And we cant join two fact tables.
I have used below expression to my chart
count({<[Medical Event ID]= P({<Table_Name= {'Event Attendee'}>}[Medical Event ID]),Table_Name= {'Call Detail'}>}1
)
But When i select call status filter the chart is going blank which i used above expression in Chart,I want to display the chart even call related filters are selected.
Possible values to be captured medical event id for these calls from event attendee table
Please help me what modification should i change in above expression?
