Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Standard table Second-level row field Not filtered.

Hello experts

 

Hi Experts

 

I am using a standard table in power bi from the screen image below the Agent Name is in the Rows field which filter perfectly when in add the pay zone ref from the second bridge table to the row field standard table - it does not filter down the data to pay zone level.

 

The agent name comes from Agent Bridge Table

The Payzone Ref comes from Pay zone Bridge Table

Both bridge tables have unique values.

 

Measure when using Agent Bridge Table

Previous Period B/f =
VAR MinDate = MIN('STG Dim_Date'[FirstDayOfMonth])
VAR MaxDate = MAX('STG Dim_Date'[FirstDayOfMonth])
VAR LastWeek = MAX('STG Dim_Date'[LastDayOfMonth])

RETURN

CALCULATE(COUNT('STG Fact_To_Do_Created'[Closed]),
FILTER(ALLEXCEPT('STG Fact_To_Do_Created','Agent_Names'[Agent_Name], Agent_Names[Department]),
'STG Fact_To_Do_Created'[Created_Date] < MinDate &&
'STG Fact_To_Do_Created'[Date_Closed] >= MaxDate && 'STG Fact_To_Do_Created'[Date_Closed] <= LastWeek && 'STG Fact_To_Do_Created'[Created_Date]<>BLANK()),CROSSFILTER('STG Fact_To_Do_Created'[Created_By_FullName],'Agent_Names'[Agent_Name],Both))

 

See image

 second image to show data not filtering in end table

 

 

 

 

Need Help

6 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    my measure for re-connected 

    Re-Contracted = CALCULATE(
    COUNTROWS('STG Fact_To_Do_Closed'),
    'STG Fact_To_Do_Closed'[Task_Results] ="Resigned - New Agreement" ||
    'STG Fact_To_Do_Closed'[Task_Results] ="Resigned New Agreement – Terminal Ordered")
     
    if this helps - i might be missing something