The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
The totals don't add the table after I applied filters. Here are only 21 items on the list yet the count shows 75. Same happens if I change to Sum. Still way more than the total on the list.
Solved! Go to Solution.
This seems to be related to your table relationship. If you can change the cross filter direction between tblProjects and tblEvents from Single to Both, then we should be able to get the expected result.
Best Regards,
Herbert
This seems to be related to your table relationship. If you can change the cross filter direction between tblProjects and tblEvents from Single to Both, then we should be able to get the expected result.
Best Regards,
Herbert
Is it possible to share your PBIX file through online file service like OneDrive to me?
Best Regards,
Herbert
I Use 3 tables
Tables
When looking at the filters, the smallest set = 21 items (Events in year 2017) which is the same as on the list. However, the total is for the field RealNetValue on tblProjects which is 209 projects.
Project Filter
Event Filter
So the list adheres to all filters applied, the totals don't. It only summarise based on the filter for the table where the filed occurs. In this example, the list shows the 21 items where all conditions are true but the value & count ignores the condition where the minimum is all true. Thus the totals follows OR rather than AND.
I cannot repro the same issue on my side. Are these columns from one table? How do you apply the filters? Please refer to my recorded video below and let me know if there is any difference between our repro steps.
Best Regards,
Herbert
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
102 | |
97 | |
80 | |
62 | |
57 |
User | Count |
---|---|
262 | |
120 | |
115 | |
83 | |
70 |