matrix chart

[mya]

Hi 

I want to create a matrix chart with period date and region as coulumn header and category as row header .. 

Values - to get the distinct count of the customer who have a order amount greater than a parameter value . 

Also have to get the sum of the sales for each catergory . 

Please help . 

[v-yaningy-msft · Accepted solution]

Hi, @mya 

Based on your description, I have created some measures to achieve the effect you are looking for. Following picture shows the effect of the display.

Matrix:

Distinct count of the customer:

Total sales by Category:

Measure:

DistinctCountSales =

VAR SelectedValue = SELECTEDVALUE('Parameter'[Parameter])

RETURN

    CALCULATE(

        DISTINCTCOUNT('Table'[Sales]),

        'Table'[Sales] > SelectedValue

    )



TotalSales =

SUMX(

    SUMMARIZE('Table', 'Table'[Category], "Total Sales", SUM('Table'[Sales])),

    [Total Sales]

)

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum