Forum Discussion
Issue with data summary in table
hello,
I am using a slicer for the dates for adjusting the table below.
I used "Sum" as the summary for the column RDOT. It has now 3 rows and the sum should be 3 instead its giving a wierd figure. Any guesses on whats wrong ?
hello v-haibl-msft,
I found a work around solution for this. I was using certain Visual Level filters previously , which i made as Page level filter and the data summary is correct now.
Regards
Prabhu
4 Replies
I only see 2 rows in your screenshot. Do you mean that the Total value should be 2 but not 731?
Based on my testing, if RDOT is a column, the Total value is correct which will be changed according to the date slicer selection.
If possible, could you please provide you PBIX file to me?
Best Regards,
Herbert
hello v-haibl-msft,
You got it. The total value should be 2. (sum of 1 and 1). However its shown as 731.
The report has to do with certain organisation data and i am unsure if i can share the pbix to you. I will try to replicate this issue using some dummy data and send you. Is that fine ?
Regards
Prabhu
hello v-haibl-msft,
I found a work around solution for this. I was using certain Visual Level filters previously , which i made as Page level filter and the data summary is correct now.
Regards
Prabhu
