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.
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?
Solved! Go to Solution.
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:
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
Hi @v-huizhn-msft I've since then figured out the issue to my problem. Thanks for reaching out!
Hi @Anonymous.
Congratulations, you resolve your issue by yourself, welcome to share your workaround,or you'b better mark your reply as answer. So more people benefit from here.
Best Regards,
Angelia
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:
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 |
---|---|
113 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |