Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Need modelling help

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

 

 

Need Help
Show and Tell
  • powerbidev123's avatar
    powerbidev123
    1 year ago

    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.

4 Replies

  • Cookistador's avatar
    Cookistador
    Super User
    1 year ago

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

    • Deku's avatar
      Deku
      Super User
      1 year ago

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

  • DineshYadl's avatar
    DineshYadl
    Helper I
    1 year ago

    Hi Anonymous 

     

    Please share sample dataset atleast 10 records.

     

    Thanks.

  • powerbidev123's avatar
    powerbidev123
    Solution Sage
    1 year ago

    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.