Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 |
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
Best regards
Bruno Costa | Super User
Did I help you to answer your question? Accepted my post as a solution! Appreciate your Kudos!!
Take a look at the blog: PBI Portugal
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
99 | |
97 | |
85 | |
70 | |
67 |
User | Count |
---|---|
116 | |
109 | |
94 | |
79 | |
72 |