Don't miss your chance to take exam DP-600 or DP-700 on us!
Request nowLearn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register 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
)
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
Check out the February 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 54 | |
| 47 | |
| 39 | |
| 16 | |
| 15 |
| User | Count |
|---|---|
| 83 | |
| 70 | |
| 38 | |
| 28 | |
| 27 |