Drill thru page returning all results (not filtered results)

[Anonymous]

Hello Community:  

Situation is I've got a drill thru from one page to another. The "expected" behavior is that the drill thru page should return a filtered list of orders on a table on that page.  If I have a certain measure on that table (the first one listed below), the drill thru page returns ALL records...not the ones that should have been filtered from the originating page. If I remove that measure from the table I get the filtered list. So I need to fix that measure (or one of the measures in that measure).  Below are the measures involved.    

Again, my end goal is that the table on the drill thru page just shows the filtered results, not all records.

Order Performance Measure (Early + On Time %) =

1 - DIVIDE ( ([LateOrderCount]),[Number of Orders] )

LateOrderCount =

CALCULATE ( DISTINCTCOUNT ( ShippedOrdersALL_Query[Order Number] ),ShippedOrdersALL_Query[Exclude Weekends_On Time Status] = "Late" )

Number of Orders =

CALCULATE(

DISTINCTCOUNT(ShippedOrdersALL_Query[Order Number]),

'Dim_Date Table'[DatesWithShipDates] = True)

[YukiK]

Such an odd behavior! I'd just double check to make sure your tables are related properly.

[Anonymous · Accepted solution]

@YukiK 

The original measure was the problem.   It's been fixed below, but it's created another problem, but less significant.  

What was causing the issue of all of the lines being counted was the 1 - Divide which caused the table to return all values.  

The measure below solves that problem, but what is happening now is that for the rows that are "Late" it is just showing a blank value.    I could do a quick fix by just adding a + 0 to the end of the measure, but this will end up causing my original issue again, of showing all rows, not just the filtered ones.  

I need the rows showing blanks to show 0% .   You can't see it in my screen shot, but these Orders are Late orders.   And because Late = 0% on time, then the value those rows should show is 0%.   



Order Performance Measure (Early + On Time %) =

DIVIDE ( [EarlyOrderCount] + [OnTimeOrderCount],[Number of Orders] )

[v-jingzhang]

Hi @Anonymous 

Try if this measure works

Order Performance Measure (Early + On Time %) =
IF (
    ISBLANK ( [Number of Orders] ),
    BLANK (),
    DIVIDE ( [EarlyOrderCount] + [OnTimeOrderCount], [Number of Orders] ) + 0
)

Or 

Order Performance Measure (Early + On Time %) =
IF (
    NOT ( ISBLANK ( [Number of Orders] ) ),
    1 - DIVIDE ( [LateOrderCount], [Number of Orders] )
)

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.