Forum Discussion
Weird Matrix Visual behavior
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 - what is the measure calculation?
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 - 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 - I should add - Total is also calculated, according to the DAX formula. It is not the sum of the parts.
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 - 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.