Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

dimension

i have 2 tables and i need to create a dimension form the column called " deaign Work package'

the tables

1. Actual Hours 

2. Actual Cost

i need a dimension from the values of these columns so i can  connect to them 

how to write the DAX code?

 

thanks

 

 

Need Help
  • SpartaBI's avatar
    SpartaBI
    4 years ago

    Anonymous this is the code for the calculated dimension table:

     

    Design Work Package Dimension = 
DISTINCT(
    UNION(
        DISTINCT('Actual Hours'[Design Work Package]), 
        DISTINCT('Actual Costs'[Design Work Package])
    )
)

     





          

    Showcase Report – Contoso By SpartaBI

1 Reply

  • SpartaBI's avatar
    SpartaBI
    Community Champion
    4 years ago

    Anonymous this is the code for the calculated dimension table:

     

    Design Work Package Dimension = 
DISTINCT(
    UNION(
        DISTINCT('Actual Hours'[Design Work Package]), 
        DISTINCT('Actual Costs'[Design Work Package])
    )
)

     





          

    Showcase Report – Contoso By SpartaBI