Compiling Formula Results?

[Anonymous]

I've gotten a strange request I'm not sure is possible. So I have data that looks like this:

So the overall average for this group of people is of course -17.39. I've been asked that instead of seeing each person's NPS individually, how I can have the -17.39 appear for everyone? We'd rather just see what the overall number is for the group. I'm not sure how to do this since PBI by default will take the formula and apply it separately to everyone's name once added to any visual...

[Anonymous]

Try adding ALL(TableName) to your calculate function

[Anonymous]

@Anonymous where at exactly in the formula? Not familiar with how to use that.

[Anonymous · Accepted solution]

Maybe something like:

NPS =
CALCULATE(
   [TTM Average],
   ALL(TableName),
   DATEADD('Date'[Date],-1,QUARTER)
)

This will reset your filter in your table to use all of your data instead of dividing up by the rows. This might depend on how you're calculating TTM Average though.

Hope this helps,

Parker