Forum Discussion
Anonymous
4 years agoNot applicable
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...
amitchandak
Super User
4 years agoAnonymous , Not very clear. We should prefer star schmea, but it will work without that too. Not sure what do you mean by Auto-Exist.
An example where the star schema plays a role. Say I want to ignore filter on date, but do not want other filters to get impacted , then we can use all on date table
It also help to force row context after using all or allselected
This Period = CALCULATE(sum('Table'[Qty]), FILTER(ALL(Period),Period[Period Rank]=max(Period[Period Rank])))
In the above case, you do need to worry about other dimensions, you will get the current period for all dimensions correctly.
If I use it in a single table I have to add condition to handle all other parameters
Can explain with example what is the issue