Add a global setting to never auto summarize
We have some reporting requirements that can involve pulling in hundreds of columns of data, yes we've suggested better ways to do this, but for some ingest feeds that's what came as the client requirement. This for one starts to get rather pokey, but it's extra annoying when PowerBI decides to summarize each field and you have to go in and tell it not to summarize for dozens of them. There should be a global setting to not summarize new columns you can toggle on and off once, like there's a pause updates feature.
Count and Sum shows wrong results
I need your support for the below issue. I have connected my excel to power BI and generated graphs. While generating the reports I am facing the below issue: 1. Sum Function: I am calculating man-hours spent on each property, In the below chart "Total man-hours by property" based on the filter, it should show the value as 4 but it shows the wrong value as 6. Please refer to the table below, where the correct value is 2+2 = 4 (total hours spent) is shown; but in the chart, it is showing wrongly. When I make a sum the result is showing wrong with more value and I need your support to fix it. 2. Count Value: In the below chart name "Count of property visits", here actually it should show the result as 2, but it shows a wrong result as 3. Can you please advise on how to fix it. I hope I have clarified my query. Looking forward to your support.
Wrong Sum totals when using a SUM measure from two different Tables
Dear All PBI Users, I am getting the wrong columnb totals when i create a measure between two different tables. See Attached picture. How do i solve this. The formula i have used in shown in the formula bar. Kindly this is urgent if someone could assist at the soonest Thanks
