March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch 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)
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
User | Count |
---|---|
90 | |
89 | |
85 | |
73 | |
49 |
User | Count |
---|---|
167 | |
149 | |
93 | |
72 | |
58 |