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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.