Need modelling help

Use DAX Measures with Conditional Logic

Let’s say your table looks like this:

| Version | Model | Cost1 | Cost2 |

You can replace Cost1 and Cost2 columns with measures that blank out values based on the Version:

Step 1: Create measures
Cost1_Display =
IF(
SELECTEDVALUE('Table'[Version]) = "V2",
[Cost1], // Use your actual measure or column here
BLANK()
)

Cost2_Display =
IF(
SELECTEDVALUE('Table'[Version]) = "V1",
[Cost2],
BLANK()
)
If Cost1 and Cost2 are columns and not measures, replace [Cost1] with MAX('Table'[Cost1]) or SUM, depending on your data structure.