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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Anonymous
Not applicable

Numbers next to Filters changing by Page

Hi

You know how there is a number when you have a filter for a page or a view. It usually shows the number of rows in the table for that particular filter value. 

 

CustStats.jpg

I am running into this issue - where for each page it is showing a different value. 

 

Here are the things I checked and excluded from reasons

1. Other Filters affecting it - Page or Visual Level 

2. Using the same metric and calculation 

 

 

Does anybody have any insight ? This looks like a major drawback of Power BI. 

 

 

2 REPLIES 2
dax
Community Support
Community Support

Hi @Anonymous , 

I am not clear about your design, did you check whether other filters or relationship affect this filter? If possible, could you please inform me more detailed information(such as your design or your file by OneDrive for Business(you could use simple sample and virtual data))? Then I will help you more correctly.

Please do mask sensitive data before uploading.

Thanks for your understanding and support.
Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous
Not applicable

Let me see if I can simply it.

There are two filters that affect a measure that goes into 3 different reports. 

Filter one X - is used to measure X1 from table table_X

Filter two Y is used to measure Y1 from table table_Y

 

Both filters are used in conjuction 

There are 3 reports that we leverage these filters for. 

 

Report 1 measures Metric 1 - is a direct function of X1 

Report 2 measures Metric 2 - is a direct funtion of Y1 

Report 3 measure Metric 3 - is an indrect function of Y (It has an inverse and disjointed relation to Y) 

 

Table_X and Table_Y have a relationship established between them based on a common field. 

 

What is happening here which caused me to post this was that - Report 1, 2 and 3 shows different values of aggregation (values) for Filters X and Y. (See the picture above - one is 16k the other is 14k). 

 

When I tried to recreate this after a month, the issue is not exsistant. As in all Reports are showing the same numbers. But would be better to get some numbers back on.

 

 

Thanks

Sidharth 

 

 

 

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors