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.

     

     

     

Natarajan_M's avatar
Natarajan_M
Super User
4 months ago

Hi PowerBIUser1990 , Let me ask the question in a different way ?

How to identify which level to use for each row 



For example
Case 1 
if the level 1 is outdoor and level 2 is outdoor structures woodland and crops the required op is outdoor structures (Level 2)
Case 2 
if the level 1 is outdoor and level 2 is grassland woodland and crops the required op is outdoor ( level 1)

How we know when to choose level1 and level2 
on what basis ? whats the criteria ? if you can share this then we can resolve this issue 

Thanks 


 

PowerBIUser1990's avatar
PowerBIUser1990
New Member
4 months ago

Not sure I can explain it in another way. Thanks for your help anyway I will just advise my Manager I cannot provide what he wants.

  • v-tejrama's avatar
    v-tejrama
    Community Support
    4 months ago

    Hi PowerBIUser1990 ,

     

    Thank you Natarajan_M  for the response provided!

    Has your issue been resolved? If the response provided by the community member addressed your query, could you please confirm? It helps us ensure that the solutions provided are effective and beneficial for everyone.

    Thank you.