Forum Discussion
DAX Measure SUM Behavior Question
Hmm, I thought the purpose of the slicer was to change the display context? Why would a measure override this? Just looking to understand this. How do you handle scenarios where you want to show 0 as a value instead of blank? I can't filter the visual for zero values as it won't show 0 on days where it is 0.
What is the correct way to handle scenarios where you want to show a value as 0 instead of blank since a measure won't respect a filter.
In the previous screenshot, how would you show the value for a specific date (that's what I used the slicer for) when the value is blank but you want to show that as 0?
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.pbixHi 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,