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

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.

Reply
Anonymous
Not applicable

Filtering master table with two dim Table

Hi,
I am having a power bi model with one master table and two dim tables namely 1) Unique Employee List 2) Date Table(Created by calendar Auto).
My master table contains data about cases with unique case numbers having an employee name as case owner, its created date, and resolved date.

Unique employee List <one to many> Master table <many to one> Date table

1) Employee List relationship
2) Date table to Created Date

Now I want a simple card showing the count of cases and two slicers 1) Unique employee List 2) Date Table.
I want to know for a certain employee what was the case created count for a year or any time period.

The problem I am facing is its not showing the correct number.

I tried with taking the slicer from the master table "created date" and it came out to be right, but I want to have a separate date table.

Please advise!

 

5 REPLIES 5
PaulDBrown
Community Champion
Community Champion

@Anonymous 

What is the measure you are using which delivers unexpected results?

From your description, a simple DISTINCTCOUNT(Master table[Case Id]) should work





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






Anonymous
Not applicable

I am using the same measure you meantioned

@Anonymous 

 

Can you provide a dummy sample dataset?

Also, a depiction of the results you get with both measures and a table visiual with slicers applied





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






mpicca13
Resolver IV
Resolver IV

@Anonymous Can you provide an image of your model?

Anonymous
Not applicable

Abhi_51234_0-1602234211314.png

This is the model

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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