Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
I need help with DAX.
So I have tow tables namely Batch and Sentiment.
As you can see Batch Table has a company name and one comapny can have multiple assets.
Similary in Sentiment table, one asset can have multiple sentiments
Now I need to know for one company there are how many sentiments?
Like for company ASDA having Green, Animal,Yellow,Bird as assets and they have in total 8 sentiments.
So for ASDA value should be 8.
Similarly for other companies.
Can someone please guide me on this ? @SpartaBI
Solved! Go to Solution.
You basically just need to create a realetionship based on asset column, but I will pm you anyway
@Saswa_D my pleasure.
Make sure that all of the assets are in both tables otherwise you will lose information as in m:m cardinality the blank row concept is not applicable.
Hey @SpartaBI , I might not be able to share the PBIX. The above data is just the dummy data for reference. I was looking for help in aggregating the sentiments for each company.
Can you please see if you can help here
You basically just need to create a realetionship based on asset column, but I will pm you anyway
Thank You very much, It comes as a many to many relationship but seems that is the easy way to get this done.
Thanks again
@Saswa_D my pleasure.
Make sure that all of the assets are in both tables otherwise you will lose information as in m:m cardinality the blank row concept is not applicable.
Hey, will pm you
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
10 | |
9 | |
8 | |
8 | |
7 |
User | Count |
---|---|
14 | |
12 | |
11 | |
10 | |
8 |