Forum Discussion

mya's avatar
mya
Frequent Visitor
2 years ago
Solved

matrix chart

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 . 

Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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