Forum Discussion
TABLE VIEW AND REPORT SHOWING DIFFERENT FIGURES
I am having a weird challenge. The table view of my project is showing the correct count of rows(11273) and sum of the value field shows(310M) based on the source data. A DAX measure on the coun...
Thank you @lbendlin and v-yalanwu-msft .
I have tried to fix this error using the suggested solution but the issue is still persisting.
I think I should provide more details. I imported sales data for 2months- say August and September 2022 using the folder options of Getdata. The two months sales data were combined in the power query. I have a filter by month slicer on my visuals. The measure that calculates total monthly sales returns the correct figure for August, but returns incorrect sales figure for September. I am just wondering where I have erroneously placed a filter that affects only September sales figure.