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! Get ahead of the game and start preparing now! Learn more
| 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! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 40 | |
| 36 | |
| 34 | |
| 31 | |
| 27 |
| User | Count |
|---|---|
| 136 | |
| 103 | |
| 66 | |
| 65 | |
| 56 |