Weird Matrix Visual behavior

[Anonymous]

Hi Community

Can pls anyone explaine how this can be possible  (sum of values do not match totals)? Isn't total supposed to show colulmn sum?
Values are a measure (dtype :Whole number) that sourced a column where values are -1,0,1.

No report/page/visual level filter applied.

[Anonymous]

@Anonymous - what is the measure calculation?

[Anonymous]

hi @Anonymous calculation means DAX formula?

MTD LY =
IF(Data[Year]=Min(Data[Year]) && MONTH(Data[Yesterday_Region]+1)+IF(Data[Report]="PY",12,0)=Data[Month Sorter]-1
&& Data[DateYr]>Data[Yesterday_Region],0,IF(Data[Year]=Min(Data[Year]),Data[Mapped_Pax],0))

[Anonymous]

@Anonymous - The reason for the behavior is that the DAX formula does different things in based on different Filter contexts. Because of the logic built in, it is not additive.

Does it make sense?

[Anonymous]

---

@Anonymous wrote:

@Anonymous - The reason for the behavior is that the DAX formula does different things in based on different Filter contexts. Because of the logic built in, it is not additive.

Does it make sense?

---

not really, can you plese elaborate or give an example?

the question is what to do with this, rewrite measure formula?

[Anonymous · Accepted solution]

@Anonymous - Here's a simpler example of a measure that is not additive:

Only 2018 = IF(SELECTEDVALUE('Date'[Year]) = 2018, [Sales],0)

The logic states that if there is only one year involved, and that year is 2018, then we calculate the results. Otherwise, it's 0.

In order to suggest another solution, I first need to understand what exactly the requirements are.

[Anonymous]

@Anonymous - I should add - Total is also calculated, according to the DAX formula. It is not the sum of the parts.