Hello everybody.
In a performance dashboard with numerous KPIs, we have data for 10 key customers. We have a frontpage where we choose (i.e. slice) the customer we want to see data for on all the remaining pages.
Our challenge is that we need to show benchmark (that is, the average value for all customers) for all KPIs in the dashboard. However, we are not interested in including the selected customer in the benchmark.
We have figured out how to get the average value by using the DAX formula “ALL” (so it ignores the filter on the frontpage), but we need help on how to exclude the selected customer (which is chosen in the frontpage).
This dax calculation is the closest we have come to an option, but it's not showing the right number as when we calculated it manually:
Benchmark = CALCULATE( [KPI] ,EXCEPT(ALL(CompanyTable),CompanyTable))
Our dataset is confidential, so we can not provide you with it.
Thank you.
