DAX for attributes which exist in a single column

[PaisleyPrince]

Hi,

I have a situation where a dataset has a number of attribute values in a single column and I need to be able to filter report visuals based on the selection of attribute values., so that they show the number of properties which match each combination of attribute values. Some sample data is as follows for the Dimension and Fact tables. Could anyone advise what the best way would be to do this in DAX or whether a better method would be splitting out the dimension values which currently reside in a single column ?

[dharmendars007 · Accepted solution]

Hello @PaisleyPrince , 

Please try the below using Power Query

1. Split the "Attributes" column by the delimiter ";" , and then use the "Unpivot" feature to move those split values into rows.

2. Create a relationship between the unpivoted "Attributes" column and the "DIM Code" in your Dimension table.

3. This setup will allow you to filter properties based on their individual attributes via slicers or filters.

If you find this helpful , please mark it as solution and Your Kudos are much appreciated!

Thank You

Dharmendar S

LinkedIN