Forum Discussion
Creating a KPI "Goal" To Remain Constant Using All Function
Hi All,
New to BI and running across a frustrating problem. I'm essentially trying to create a constant KPI or figure...for instance, I'm trying to create a company wide measure that stays constant no matter the filter, slicer, etc. so when a visual or filter/slicer is clicked on a specific sales market, it shows that specific market's measure as the "Indicator" and compares it against the company wide measure or the "goal". What I'm finding is that when the a visual/filter/slicer is clicked, the goal will change to whatever the indicator is, so the goal is not staying constant at that company-level measure. Here's the measure I have created for the "goal" to attempt and get the measure to stay constant regardless of any locations picked:
CALCULATE(([Weighted Avg Blank]+[Weighted Avg Corp]+[Weighted Avg Fran]+[Weighted Avg Mixed]),all(ALL_ORACLE_FZSEIPL_UNPIV[Location]))
Any suggestions or help would be greatly appreciated! And just for reference, here's the other measure that is acting as the indicator if that's helpful:
Weighted Avg Total = [Weighted Avg Blank]+[Weighted Avg Corp]+[Weighted Avg Fran]+[Weighted Avg Mixed]
