Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Saswa_D
Frequent Visitor

DAX query

I need help with DAX.

So I have tow tables namely Batch and Sentiment.

Saswa_D_0-1657448786175.png

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

Saswa_D_1-1657448857247.png

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 

2 ACCEPTED SOLUTIONS
SpartaBI
Community Champion
Community Champion

You basically just need to create a realetionship based on asset column, but I will pm you anyway

View solution in original post

SpartaBI
Community Champion
Community Champion

@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.

View solution in original post

6 REPLIES 6
SpartaBI
Community Champion
Community Champion

@Saswa_D can you share the pbix and I will return one with solution

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

SpartaBI
Community Champion
Community Champion

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

SpartaBI
Community Champion
Community Champion

@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.

SpartaBI
Community Champion
Community Champion

Hey, will pm you

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors