Forum Discussion
Measure giving different results in different visuals
Hi PaulR17 ,
As TomMartens said, the current row context and filter context will affect the result of measure. Please refer to for more details:
https://www.sqlbi.com/articles/row-context-and-filter-context-in-dax/
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Super UserHey PaulR17 ,
this is difficult to answer.
What you have to consider whenever a measure is evaluated, is the concept known as Filter context,
Ths means, everything that filters a table contributes to the filter context, of course, this is only valid for columns from tables that have an impact on the numeric expression, the first parameter of the CALCULATE function.
The measure (I assume it is a measure), the 2nd parameter of the SUMX, is impacted by the filter context.
Column header of a table visual, column and row headers of the matrix visual, columns used on the axis of a visual, as well as the legend are forming the filter context. Of course also slicers are contributing to filter context.
Hopefully, this provides some ideas on what's going on.
Regards,
Tom
Hi TomMartens
Thank you for the advice.
I have made sure that all the filters are the same for both visuals, but it doesn't stop the results being wildely and inconsistently different.
I'll keep plugging away 🙂
