Forum Discussion
Will this work to avoid Auto-Exist . . ?
Hi everyone. A while ago, I ran into an issue related to a concept in Power BI called "Auto-Exist". Due to this, one is forced (not sure if forced is the right word) to strictly adhere to a Star Sche...
V-lianl-msft
Community Support
Community SupportHi Anonymous ,
In a regular star schema where dimensions are linked to the fact table, auto-exist only operates on dimensions.If a column has to be used to slice and dice, then it needs to belong to a dimension. Numbers to aggregate, on the other hand, are stored in fact tables.
For more details,you can refer to:https://www.sqlbi.com/articles/understanding-dax-auto-exist/
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.