cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
aboodhamwi
Frequent Visitor

Table is not filtering as expected

Hi,

I have one report, the data is from the CDS, the structure of the data is, I have Contract table, under that table there is Agreements table, the contract is the parent, now In the report, there is one page for contracts details, as a table, and I made another page where it will show the Agreements, I made the Drill-through, it's working in a way, but not fully, this is the table of contracts

2020-07-22_14-07-02.png

and once I will do drill through, it should only show me the agreements of that contract, now for some reason, the result is, the agreements of that contract, an empty line, then all agreements, I want only the agreements of that contract to show and not the rest 

 

2020-07-22_14-05-12.png

1 ACCEPTED SOLUTION

Thanks @amitchandak for pointing me to the correct place, the problem was, in one my measure, i had an If, and that was the cause

View solution in original post

3 REPLIES 3
amitchandak
Super User IV
Super User IV

@aboodhamwi , do you have any measure with +0 .

Or you checked this option by mistake - Show item with No data

ShowItemwithoutdata.JPG



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Hi @amitchandak ,

 

Yes, I do have measure, is this the problem?

Thanks @amitchandak for pointing me to the correct place, the problem was, in one my measure, i had an If, and that was the cause

View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors