Forum Discussion

PowerBIUser1990's avatar
PowerBIUser1990
New Member
4 months ago
Solved

Combining Column Data

Hi, I am new to Power BI and have been given the task of creating dashboards for property types in my local area. The database being used has 4 levels for each property type but only some are requir...
Need Help
  • rohit1991's avatar
    rohit1991
    4 months ago

    Hii PowerBIUser1990 

     

    You can create a calculated column to always return the deepest non-blank level using DAX:

    Property Type =
COALESCE(
    'Table'[Level 4],
    'Table'[Level 3],
    'Table'[Level 2],
    'Table'[Level 1]
)

    For Property Category, if it is driven by Level 2:

     

    Property Category =
COALESCE('Table'[Level 2], 'Table'[Level 1])

    This ensures consistent classification and works correctly across all visuals and slicers.

     

     

     

rohit1991's avatar
rohit1991
Super User
4 months ago

Hii PowerBIUser1990 

 

You can create a calculated column to always return the deepest non-blank level using DAX:

Property Type =
COALESCE(
    'Table'[Level 4],
    'Table'[Level 3],
    'Table'[Level 2],
    'Table'[Level 1]
)

For Property Category, if it is driven by Level 2:

 

Property Category =
COALESCE('Table'[Level 2], 'Table'[Level 1])

This ensures consistent classification and works correctly across all visuals and slicers.

 

 

 

  • PowerBIUser1990's avatar
    PowerBIUser1990
    New Member
    4 months ago

    Hi rohit1991, this works really well for the Property Type but some of the Property Categorys come from Level 1 as well as Level 2