Forum Discussion
ALL Function Not Working
I have this table with this data:
On a different dashboard I've done the exact same thing and for the LQ NPS column it returns the overall score rather than the score of each individual person. So for this it should say 14.52 for everyone. I'm not sure where to pinpoint why this would be behaving differently?
Hi v-huizhn-msft I made a small change to the formula to get it to work. Here is it what it now looks like:
So inside my ALL, I'm referencing the table where everybody's names are consolidated. In my original 'NPS Consolidated' table, people can appear as a Flex or Cobra manager, but they tend to be the same person. I made an additional table called 'NPS Consolidated (2)' specifically for hosting the names of these managers so we can see all records together whether they are Flex or Cobra managers:
So the [LQ NPS] formula comes from my 'NPS Consolidated' table, but I was attempting to use the [Value] column from 'NPS Consolidated (2)' to display my results, thinking it would automatically pick up the ALL function since the 2 tables are related. Once I referenced the table where the names are actually consolidated together rather than where the formula is hosted, it worked fine:
6 Replies
- What is the formula for your measure used in your CALCULATE?
Hi Anonymous,
Do you mind share your .pbix file for troubleshooting the cause of not working? It's hard to reproduce your scenario without data.
Best Regards,
Angelia
