Hi forum experts,
I'm working with a power pivot data model as shown here. I'm using some simple measures:
Count the number of distinct activities:
Distinct Activities = calculate(DISTINCTCOUNT(ServiceDetails[Activity ID]))
Assign a status based on the volume of activities:
Service Status = if([Distinct Activities]>=5,2,IF([Distinct Activities]=0,0,1))
I have a pivot table with a slicer to select "Consultant Name" and show the activities and status for that consultant against different accounts in rows ("Master Group").
The RHS table contains feedback from sales people (Addressable? Yes/No) on whether consultants should be servicing specific accounts. I want to add a second slicer to my pivot table based on this field so that I can filter the view for "Yes" vs. "No" results.
Since the directionality is going the wrong way, I made a CROSSFILTER measure. But clicking Yes or No on the slicer generates different values instead of just filtering the view.
Addressable Service Status = CALCULATE([Service Status], CROSSFILTER (EmployeeTeams[Consultant Name], SalesFeedbackTable[Consultant Name], Both))
I'm a novice at this and wonder what I'm doing wrong. Advice very much appreciated.
datamodel.jpg
Bookmarks