Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Hi
I am trying to make measure satisfaction on diffrent customers. Each customer can have multiple tasks assigned to them and each task has multiple questionforms with diffrent satisfaction levels that I am trying to sum up. It looks like this.
The problem is that their are 1000s of small unimportant customers without any questionforms assinged to them.
I want the end user to be able to filter on the diffrent customers, but only see the customers in the filter which have answered a questionform.
I also would prefer to use PowerBI own filter to the right on the PowerBIsharepoint if that is possible. So far my solution has been to add two filters a hidden and a visible one. And only include the customers I need like this.
But I would prefer to only show the relevant customers dynamicly. I cannot add measures to powerBIs own filter and due to the direction of the relationship I cannot just remove all the customers without a satisfaction questionform so what should I do here?
Thanks for the quick response. I think that would remove some of the data that I need other places in the report.
What if I am willing to use the visualisation filter
Then could I write a meassure that allows me only include the relevant customers?
@ThomasWeppler , I doubt you can pass value to source dynamically. You can use power query parameter for filtering the data you bring in
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 104 | |
| 82 | |
| 72 | |
| 46 | |
| 35 |