Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I have three measures that are working correctly...although I now need to update them in order to consider one of the page filters I have added to the page.
Here are my current measures that I need to update:
As you can see in the following image, these three measures are being used as the Column Values of the visual. You'll also notice that I am using the field Result as the Shared Axis:
These measures are all calculating correctly for all Groups. But I now need to have a page drop down filter where I can select a specific group and have this bar chart visual update based on the selection. As you can see in the photo above, I have added the filter. However, when I change a selection it is not interacting with the visual.
Here is an image of the relationship map:
- The Employer Group filter is populated with the Group Name field in the EmployerGroups table
- The EmployerGroups table has a one to many relationship with the Post Call to Home Append table based on the Group ID column which is present in both tables
- I needed to create the Successful Intervention Passthrough table in order to assist in being able to create the Totals result...so I could plot Total, Yes and No results on the same table.
But now, with the three formulas that I mentioned earlier...I have no idea how to update them (how to re-write them) so they will interact with the Employer Group filter...because the Employer Group filter (that is populated by the field Group Name in the table Employer Groups) has no direct relationship with the Successful Intervention Passthrough table.
Can you PLEASE assist me here????
Thank you,
Andrew
Solved! Go to Solution.
Hi, @AW1976NOVA
ALL function ignores all filters, regardless of where they are coming from. In contrast, the ALLSELECTED function only ignores filters that are coming from the inner query.
Take a try to replace ALL function with ALLSELECTED function.
Best Regards,
Community Support Team _ Eason
Hi, @AW1976NOVA
ALL function ignores all filters, regardless of where they are coming from. In contrast, the ALLSELECTED function only ignores filters that are coming from the inner query.
Take a try to replace ALL function with ALLSELECTED function.
Best Regards,
Community Support Team _ Eason
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |