cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mrainey Member
Member

Compiling Formula Results?

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

1.PNG

 

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...

1 ACCEPTED SOLUTION

Accepted Solutions
Anonymous
Not applicable

Re: Compiling Formula Results?

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

View solution in original post

3 REPLIES 3
Anonymous
Not applicable

Re: Compiling Formula Results?

Try adding ALL(TableName) to your calculate function

mrainey Member
Member

Re: Compiling Formula Results?

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

Anonymous
Not applicable

Re: Compiling Formula Results?

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

View solution in original post

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 336 members 3,232 guests
Please welcome our newest community members: