Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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. 

 

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. 

 

 

Need Help

2 Replies

  • dax's avatar
    dax
    Icon for Community Support rankCommunity Support
    6 years ago

    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's avatar
      Anonymous
      Not applicable
      6 years ago

      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