Forum Discussion
SUM Measure Returns Incorrect Results With IF Statement
Hello, I'm stumped understanding what Power BI is doing. I have a simple model: I placed a filter on the dimension table Jobs to filter to a specific job: I created a simple table w...
Hi Anonymous
This is because you are forcing the calculation to return a value for all permutations of the dimentions, even if they have no data. Why are you trying to return a zero in this case?
- This was my attempt to return 0 in blank scenarios. I guess I'm not understanding why it isn't just summing with the context filters in place (job, phase, cost type). I wasn't aware it would do this across all permutations outside of the current context. How does one show 0 for values that are blank since the visual won't show blanks?