In the view we have values with respect to different groups but whenever we are taking sum for that field it was showing incorrect values.Also we use SUMX function but it was incorrect values and we checked in excel so in excel it was showing correct value and in power BI it was showing incorrect.Please suggest me any solution.We are getting incorrect count in power BI ,as I mentioned in a snippet before summarizing there are 50 rows but when we are summarizing to count I am getting 226 count in power BI,because of that whenever I am sum the records so it was showing incorrect value in total.
Helpful resources
FabCon Global Hackathon
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Power BI Monthly Update - October 2025
Check out the October 2025 Power BI update to learn about new features.
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
