Forum Discussion
DAX Measure SUM Behavior Question
Hello, I'm looking to understand the following behavior: I have the following meaures: Actual Hours SUM = SUM('Job Details'[ActualHours]) Actual Hours With Zero = VAR AH = SUM('Job Details'...
Hi Anonymous
It seems you may check 'Edit interactions' for the slicer.If the two visuals are filtered by the slicer.The slicer would change the visual when you use no matter which measures.
Regards,
Hi v-cherch-msft,
Filtering is the default behavior, and I simply dragged and dropped two tables onto the canvas followed by a slicer. Here is my file for reference. As you can see, the slicer is not filtering the meausre when I return 0 even the the table is filtered by the slicer.
Test file: Measure Behavior.pbix
Hi Anonymous
It depends on the relationships.I would suggest you use WeekEnding Slicer table's week ending column in the table.
Reference:https://www.sqlbi.com/articles/bidirectional-relationships-and-ambiguity-in-dax/
Regards,