Calculating average price using distict count??

Hi hidenseek9,

>>I would like to calculate an average price of each product for each brand by store.

For this requirement, you can direct use matrix with original column to achieve this.

Sample:

Brand, Product Name as 'Rows', Stored as 'Columns', Total as Values with summary mode average.

>>Also is there a visual to show an average price as well as the lowest and highest price of the average??

You need to write a calculated column to calculate grouped average value, then create a matrix visual with above category and new calculated column.

AVERAGE = 
VAR temp =
    SUMMARIZE (
        ALL ( 'Sample Data' ),
        [Brand],
        [Product Name],
        [Customer Danone Sales Team Name],
        "Average", AVERAGE ( [Price] )
    )
RETURN
    SELECTCOLUMNS (
        FILTER (
            temp,
            [Brand] = EARLIER ( 'Sample Data'[Brand] )
                && [Product Name] = EARLIER ( 'Sample Data'[Product Name] )
                && [Customer Danone Sales Team Name]
                    = EARLIER ( [Customer Danone Sales Team Name] )
        ),
        "AVG", [Average]
    )

Result visual: category to rows, average to values with summary mode maximum and minimum

Summary.

Expand.

Regards,

Xiaoxin Sheng