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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
PowerBIUser23
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

2 REPLIES 2
amitchandak
Super User
Super User

@PowerBIUser23 , refer if this can help

Power BI Drill Through when Userelationship is used: https://youtu.be/1BM_WGATrQA

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

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.