Forum Discussion
Quoted amount changes when it sets to sum in table
Hi,
I was wondering why the quoted amount keeps changing when I set it to sum in the table. I am trying to get the total but it keeps giving me the wrong result as it keeps switching the values.
Here is the correct values when not summarized:
And then here is the values when sum is set for the measure:
I was wondering why this is happening, and how can I get the total for quoted amount if the sum function won't work.
Thank you
2 Replies
- jdbuchanan71
Super User
You have multiple lines in your fact table for each quote number so when you add up the quoted amount you are getting the amount 1 time for each line. If you look at the first 2 lines in your screen shot the SUM of both is exactly 4x the amount meaning you have that quote in your data 4 times.
Hi gunther15 ,
How did you create the table visual? The data on the visual are from the fields of different tables? Just as gunther15 said, The value of field [Quoted amount] on the second screenshot is 4 times higher than the ones in the first screenshots, so we have to check what's going on. Could you please provide some sample data in your table (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.
How to upload PBI in Community
Best Regards
