Alter matrix display using measures in Power BI

[Ki2024]

Hi
I'm pretty new to Power BI. I've set up a number of measures and am trying to display them in a matrix visualisation in Power BI. This is what the matrix visual looks like at the moment, using Query as the rows and the 2 measures in the values field.

However, I want it to look like this:

Query	Value
22. Gender is Unknown 1	99
26. Gender is Other 1	12
Total	111

Does anyone know how I achieve this? Thanks

[Anonymous · Accepted solution]

Hi @Ki2024 

Thank you very much rajendraongole1 for your prompt reply. Allow me to offer some help.

I would speculate that your data might look something like this:

22. Gender is Unknown 1 = 
CALCULATE(
    SUM('Table'[values]),
    FILTER(
        ALL('Table'),
        'Table'[Query] = "22. Gender is Unknown 1"
    )
)

26. Gender is Other 1 = 
CALCULATE(
    SUM('Table'[values]),
    FILTER(
        ALL('Table'),
        'Table'[Query] = "26. Gender is Other 1"
    )
)

In fact, you can directly add the [Values] column to the "Values" of the matrix to achieve your expected effect.

You can get a matrix like this:

If you want to achieve this by creating a measure, try:

Value = SUM('Table'[values])

Here is the result.

If you still have problems, please provide some dummy data.

Regards,

Nono Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[rajendraongole1]

Hi @Ki2024 - Create a new calculated table to flatten the data structure.
Use the UNION function in DAX to combine data from the two measures. 

Total values = SUMX(hytr,hytr[Measure1]+hytr[Measure2])

replace with your table name as pe ryour model

CombinedTable =

UNION (

    SELECTCOLUMNS(

        Hytr,

        "Query", Hytr[Query],

        "Value", [Total values]

    ),

    SELECTCOLUMNS(

        Hytr,

        "Query", Hytr[Query],

        "Value", [Total values]

    )

)

[Ki2024]

Thanks for that. I'm really new to Power BI. Would you be able to walk me through it in more detail please?