Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Frequent Visitor

Drill Through to Filter on Specific Date Types

In my Opportunity table I have 3 date types: Created Date, Qualified Date, and Close Date.


Created Date has an Active Relationship with my Date Table while Qualified Date and Close Date have an Inactive Relationship.

I used Tabular Editor to make a Calculation group where I use SELECTEDMEASURE and USERELATIONSHIP in order to make Created, Qualified, and Close Calculation Items so I can easily switch my measures between the 3 date types.


My issue is that when I drill through on qualified or closed opportunities to my opportunity detail matrix I get those rows to appear but also the created opportunities appear. If I pull in the referenced opportunity measure it cuts down the data to the appropriate amount of rows but I want to know if there is a way where I don't need to have the measure in my matrix.


Example: March has 325 Created Opps and 200 Qualified Opps.

Screenshots below show when I have my measure as a column in the matrix and I drill through there are no issue filtering down to the specific quantity of each. However, if I remove the measure from the matrix and try to drill through on the 200 qualified I get 325 rows of data.


Thank you!

Outbound Created.PNGOutbound Qualified.PNGFilters.PNG

Super User
Super User

@PowerBIUser23 , refer if this can help

Power BI Drill Through when Userelationship is used:

This video uses 2 solutions I was hoping to avoid, which are creating seperate drill-through tables for the different date fields or having to bring a measure into the table to filter it down. My end goal is to have 1 drill-through table that will cut the data down depending on the date type I am drilling-through on, without having to have a measure in it.

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors