my values change when I add/remove detailed category column to table visual???

[Anonymous]

Hello, 

I am previewing my data in the Table visual.   I cannot understand why the summary data is different then the detail. 

My table looks like: 

Group    Year    Value

A           2019     $10

B           2019      $15

A           2020     $12

B           2020      $8

C          2020       $5

When I rmove the Group variable my table becomes:

Year Value

2019   $25

2020  $30

 I cannot understand why my 2020 summary values are MORE THAN the individual components for the same exact measures.   Any ideas?

Thanks much.  

Robert 

[Anonymous]

Hello, 

I am trying to understand why my detailed values and summary values are different.  

I am looking at my data with the Table visualization.  Which looks like: 

Group 1  Year Value

A

[v-yulgu-msft]

Hi @Anonymous,

Is there existing any filter on "Group" level? Would you please share your sample .pbix file for check? Hide sensitive data before uploading.

Regards,

Yuliana Gu

[Anonymous]

Hi Gu,

Thanks for your response.  How do I check group level filters?

Robert 

[v-yulgu-msft]

Hi @Anonymous ,

Would you please share the sample .pbix file which can reproduce the same scenario for check? Do mask sensitive data before uploading.

Regards,

Yuliana Gu

[Anonymous · Accepted solution]

Thanks for your follow up.  I figured out that the issue was I was using the 'Date'[Year] measure in the table and the linked [Year] measure in the graphic. I am completely confused as to why there is a difference in the calculation.  Thanks again.