dimension

[Anonymous]

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

[SpartaBI · Accepted solution]

@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