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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

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
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.