Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
Hi,
It would be great if you share a sample pbix file to get a quick solution. Thanks.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
95 | |
78 | |
72 | |
66 |
User | Count |
---|---|
136 | |
109 | |
104 | |
82 | |
73 |