cancel
Showing results for
Did you mean:
Post Partisan

## Dynamic weighted average?

I have a measure containing a metric for each customer.  For example:

(I added the code below for Measure)

Is it possible to get a dynamic weighted average… based on whatever segmentation is chosen at a higher level?

For example; If on the filters, segmentation X is chosen, (then that shall be Customer 4,6 and 45), and then  do a weighted average based on those Customers?

For example; If a city is seleted, (then that shall be customers 5,10 and 11), and then do a weighted average based on that?

(My goal is to use a matrix, and then in Rows to have Customer, and then do they weighted average, for whichever column is selected at a higher level and used as filter...)

My code for  Measure is.

TotalPerCustomer = SUMX(SUMMARIZE(Revenue,'Customer'[Customer]),[RevenueWo])

MaxBPerCustomer =  MAXX(  SUMMARIZE(Revenue, 'Customer'[Customer], 'Centers'[Bus]), [RevenueWo])

Measure = DIVIDE([TotalPerCustomer],[ MaxBPerCustomer],blank())

Super User

You are going to have to provide data and expected results. You have 3 customers shown with a measure and size, and then want to know how to get customers 4, 6, and 45 to do something based on some new segmentation field.

How To Ask A Technical Question If you Really Want An Answer

How to Get Your Question Answered Quickly - Give us a good and concise explanation
How to provide sample data in the Power BI Forum - Provide data in a table format per the link, or share an Excel/CSV file via OneDrive, Dropbox, etc.. Provide expected output using a screenshot of Excel or other image. Do not provide a screenshot of the source data. I cannot paste an image into Power BI tables.

Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling

Proud to be a Super User!

MCSA: BI Reporting

Announcements

#### Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

#### Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

#### What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.