Forum Discussion
Anonymous
5 years agoNot applicable
Userelationship on a calculated column with Filter issue
Hi community, Following is my dataset: My pbi file: https://1drv.ms/u/s!Ag919_pO_UKrgQhdlDIIlXqro0QP?e=Jjmbph Service_attended_date is a c...
- 5 years ago
Anonymous
Apologies since I can't check if it works since the sample you provided does not have the fields you want to filter by, but give this a try:
Services attended (more filters) = VAR CaseID = CALCULATETABLE ( VALUES ( 'Table'[Case_id] ), 'Table'[Service_code] = "Stage1", 'Table'[Service_status] IN { "Closed", "Complete" } ) VAR ServiceCaseID = CALCULATETABLE ( VALUES ( 'Table'[Service_case_id] ), 'Table'[Service_code] = "Stage1", 'Table'[Service_status] IN { "Closed", "Complete" } ) VAR FiltTable = INTERSECT ( CaseID, ServiceCaseID ) RETURN CALCULATE ( DISTINCTCOUNT ( 'Table'[Client_id] ), USERELATIONSHIP ( 'Table'[Service_attended_date], Datedim[Date] ), FiltTable )
amitchandak
5 years agoSuper User
Anonymous , this one seems to working
Services attended = CALCULATE(CALCULATE(DISTINCTCOUNT('Table'[Client_id]),FILTER('Table','Table'[Case_id] ='Table'[Service_case_id])),USERELATIONSHIP('Table'[Service_attended_date],Datedim[Date]))- Anonymous5 years agoNot applicable
amitchandak sorry this doesn't work..