Help Required in aggregation Model

[keshav_bansal]

I am trying to create a Aggreagtion Model in Power BI with a large data set (around 300 million rows) . I have my data rolled up to a ID and all my categorical fields are now Pipe delimeted . 

for eg : Table 1 ( not Rolled Up) 

ID	Categ1	Categ 2
C1	pr1	s1
C1	Pr2	s2
c2	p1	s1
c2	p3	s2
c2	p4	s3

Table 2 ( rolled up ) 

ID	Categ1	Categ 2
C1	pr1|Pr2	s1|s2
C1	Pr1|Pr3|Pr4	s1|S2|s3

Now i want to use the Categories as slicer and not in Pipe delimeted form . so I created a New Dimednsion table and tried to create a look up table for category .but Due to this i am not able to create a relationship with my dimension and aggregate table and my aggregations are not working . Any solution for this. @amitchandak @lbendlin @onurbmiguel_ 

for eg

Categ1	value
pr1|Pr2	pr1
pr1|Pr2	pr2

[onurbmiguel_]

Hi @keshav_bansal 

Can you share a pbix with some dummy values so i can understand the model. 
Also can you describe better what is the output that you want.

Best regards

Bruno Costa | Power Participant