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.
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.
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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.