Need modelling help

[Anonymous]

Hi, 

Dataset:

Version    Model     Cost1    Cost2
    
V1              A            200       300
V2              A            200       300


Result expected:

Version    Model     Cost1    Cost2
    
V1              A            Blank       300
V2              A            200       Blank

I have dataset as above and when i pull the version field into the table visual , Iget a repeated rows of model and cost as described above. How can i resolve this so that i get only single row for V1 and V2 each

[powerbidev123 · Accepted solution]

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.

[DineshYadl]

Hi @Anonymous 

Please share sample dataset atleast 10 records.

Thanks.

[Cookistador]

Can you share with us a sample or a screenshot of the data model you built ?

[Deku]

Plus a example of underlying data and the definition of any relevent measures