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
Hello community,
i have the following data:
1)Customer
| cst_code | cst_id_surrogate | FirstN | LastN |
| 1 | 151515 | Mike | James |
| 1 | 151516 | Mike | James |
| 2 | 161617 | Maria | Kallas |
2)Policy
| Plc_ID | Plc_id_surrogate | Class |
| 10001 | 10101 | Health |
| 10001 | 10102 | Life |
| 10002 | 10103 | Health |
3)Relational
| cst_id_surrogate | Plc_id_surrogate |
| 151515 | 10101 |
| 151516 | 10102 |
| 161617 | 10103 |
I want to create a measure that i can use as filter. All i need to get the customers who specific charasteristics.
In my case want to get ONLY the customer who dont have "Life" class.
I expect only cst_code = 2 as a result
Thanks in advance
Still not working as expected
Still not working
pls try this
Measure =
COUNTX(FILTER(ALL('Policy'),'Policy'[Class]<>"Life"),[Plc_id_surrogate])
Hello and thanks for you fast reply.
So how should i use this measure as filter?
Measure > 0 or?
Cause like this, doesnt look like it works.
You can apply visual level filters
Measure = IF(
COUNTROWS(FILTER(ALL('Policy'),'Policy'[Class]<>"Life"))>=1,1)
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!