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!The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!
| Model Name | OD DATE | OD1 | OD2 DATE | OD2 | OD3 DATE | OD3 |
| A | 1/3/2021 | YES | 4/4/2021 | YES | - | |
| B | 1/1/2021 | YES | 1/6/2022 | NO | 1/3/2021 | YES |
| C | 1/3/2021 | YES | 4/4/2021 | YES | 2/10/2022 | YES |
| D | 1/5/2021 | - | - | 1/1/2021 | NO |
I have created calcuated columns of OD1 OD2 OD3
I would like to show both in measure and column ways:
if we have the OD Dates and these ODs are Yes then "OK" othervise "Drop" the entire model
Solved! Go to Solution.
@SelflearningBi So maybe a Complex Selector like:
Selector Measure =
IF(
[OD DATE] <> BLANK && [OD1] = "YES" && [OD2 DATE] <> BLANK() && [OD2] = "YES" && [OD3 DATE] <> BLANK() && {OD3] = "YES",
1,
0
)
@SelflearningBi So maybe a Complex Selector like:
Selector Measure =
IF(
[OD DATE] <> BLANK && [OD1] = "YES" && [OD2 DATE] <> BLANK() && [OD2] = "YES" && [OD3 DATE] <> BLANK() && {OD3] = "YES",
1,
0
)
The Power BI Data Visualization World Championships is back! It's time to submit your entry.
Check out the January 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 61 | |
| 47 | |
| 39 | |
| 23 | |
| 23 |
| User | Count |
|---|---|
| 144 | |
| 106 | |
| 63 | |
| 38 | |
| 31 |