Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
In my data model, ServiceDetails is the main fact table with transaction records. I have a couple measures such as:
Distinct Activities = calculate(DISTINCTCOUNT(ServiceDetails[Activity ID]))
Service Status = if([Distinct Activities]>=5,2,IF([Distinct Activities]=0,0,1)). >> This is to assign a status to customers based on volume of activities
I want to add a slicer to a pivot table based on Addressable? in the SalesFeedbackTable on the far right, but the relationship directionality is in the wrong direction. This a Yes/No field that indicates whether particular accounts (Master Group) are relevant for particular Consultants.
I tried to do this with a CROSSFILTER measure, but the slicer changes the values of my Service Status measure instead of just filtering the rows in the pivot table.
Service Status - Addressable = CALCULATE([Service Status], CROSSFILTER (EmployeeTeams[Consultant Name], SalesFeedbackTable[Consultant Name], Both))
Any idea how to solve this and what I've done wrong? Thank you.
Afraid this is all in my company system so I can't share and I'm stuck with a Mac at home. My pivot table shows Master Group (which indicates company names) as rows, and the two measures I created as Values. I have one slicer for Tiering and another slicer for Consultant Name.
Service Status = if([Distinct Activities]>=5,2,IF([Distinct Activities]=0,0,1)). >> This is to assign a status to customers based on volume of activities
Service Status - Addressable = CALCULATE([Service Status], CROSSFILTER (EmployeeTeams[Consultant Name], SalesFeedbackTable[Consultant Name], Both))
As mentioned, SalesFeedback is another fact table containing a row for every combination of Master Group and Consultant Name, with a Yes or No under the "Addressable?" column to indicate whether a consultant should be servicing an account. I'm trying to add a third slicer based on this field.
What I'm finding is that the use of CROSSFILTER in the second measure causes discrepancies in output of the two measures. I've never previously used CROSSFILTER and I'm struggling to understand this! I thought that toggling between Yes and No in the slicer should alternate between the Yes or the No accounts displayed, but I'm guess that it's actualling filtering out the underlying transaction records for Yes/No designated accounts before running the measure. How can I achieve what I want - i.e just display Yes or No accounts without impacting underyling calculations!
can you share more information?
what do you currently have in your pivot?
can you give an example of what you are trying to display on the page and expected behaviour, its a bit difficult to understand without having a pbix or some sample data to test.
Proud to be a Super User!
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
58 | |
55 | |
54 | |
38 | |
29 |
User | Count |
---|---|
78 | |
62 | |
45 | |
40 | |
40 |