Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Weird Matrix Visual behavior

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.

Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    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.
     

6 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Anonymous - what is the measure calculation?

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      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's avatar
        Anonymous
        Not applicable
        7 years ago

        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?