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

Shape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.

Reply
AlanP514
Helper V
Helper V

Distinct Count

Hi
i have two tables

One is Product group table and i have a column called product mapping in product mapping i have few set of values
Asset Finance,Working Capital,Corporate Funding

Second Table called employee table
Contaiins all employee

Relationship used to connect both table is contract type and cardinality is many to many



Scanrio need to achieve : 
I wanted to findout the distinct count of employees who are present in all three product group{Asset Finance,Working Capital,Corporate Funding}

AlanP514_0-1694085686102.png

 


Apreciate help on this to achive dax


1 REPLY 1
lbendlin
Super User
Super User

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

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

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.