cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

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

 

20200926_085101.jpg

 

1 ACCEPTED SOLUTION

I can't read those screenshots. Can you take a screenshot with your computer instead of your phone's camera? The first one is so small I can't read any field.

To work around this issue, you would need to see the model. I suspect it's a field problem you're using in your cutter/filter, but I know all those two-way filters aren't helping things. Microsoft recommends minimizing the use of many-to-many, two-way relationships. In other words, unless you're a DAX expert, look for another way to reshape your data to fit a star schema and not use these two features. I avoid you both at all costs.
Microsoft's guidance on many-to-many relationships
Microsoft guidance on two-way relationships
Microsoft guidance on the importance of the star schema

How to get good help quickly. Help us help you.
How to get answers to your question quickly
How to provide sample data in the Power BI forum



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

View solution in original post

6 REPLIES 6
Anonymous
Not applicable

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

I can't read those screenshots. Can you take a screenshot with your computer instead of your phone's camera? The first one is so small I can't read any field.

To work around this issue, you would need to see the model. I suspect it's a field problem you're using in your cutter/filter, but I know all those two-way filters aren't helping things. Microsoft recommends minimizing the use of many-to-many, two-way relationships. In other words, unless you're a DAX expert, look for another way to reshape your data to fit a star schema and not use these two features. I avoid you both at all costs.
Microsoft's guidance on many-to-many relationships
Microsoft guidance on two-way relationships
Microsoft guidance on the importance of the star schema

How to get good help quickly. Help us help you.
How to get answers to your question quickly
How to provide sample data in the Power BI forum



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

View solution in original post

Anonymous
Not applicable

Thank ill provide better screen shots shortly

Anonymous
Not applicable

See attached new image.... of models

Anonymous
Not applicable

New imageNew image

Anonymous
Not applicable

Good afternoon/ evening to all power bi experts around the world

Any clues on how to resolve this lower level filtering issue?

Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors