Forum Discussion
Problem with measures aggregated on different dimensions
Hi everyone, I have a problem with a metric calculated based on a date dimension. My requirement is that the metric calculate the number of people in the organization. With two conditions: ...
I don't exactly yet understand the issue... but I can tell you that your model is not a good one. Please watch these to see how to create good, reliable and correct models:
Bear in mind that if you don't follow the Best Practices you'll be having bugs in your calculations without even realizing this. This is not a joke. Please read this to see what issues you can face:
https://www.sqlbi.com/articles/understanding-dax-auto-exist/
Also, please note that each and every sound, good model needs to have a DATE TABLE and slicing by columns of a fact table is strictly forbidden. Slicing can be only carried out through dimensions. You should have all columns in your fact tables HIDDEN.
Best
D