Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
@Anonymous - Here's a simpler example of a measure that is not additive:
@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 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:
@Anonymous - I should add - Total is also calculated, according to the DAX formula. It is not the sum of the parts.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
84 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |