Matrix table in Power bi

Hi All, Please help me with this problem if you have any idea. I'm trying to work on matrix in Power BI as given below example. Then I created Average measure to get the values after "...

Need Help

danextian

5 months ago

Hi PowerBI-P

Create a display table which is disconnected from the rest of the model, containing the column header values.

Create a measure referencing the table

Display Table Measure = 
VAR _total = [Total Transactions]
VAR _avg =
    AVERAGEX ( ALLSELECTED ( Dates[Day of Week Short] ), [Total Transactions] )
VAR _day =
    CALCULATE (
        [Total Transactions],
        TREATAS ( VALUES ( DisplayTable[Day of Week Short] ), Dates[Day of Week Short] )
    )
RETURN
    SWITCH (
        SELECTEDVALUE ( DisplayTable[Day of Week Short] ),
        "Total", _total,
        "Avg", _avg,
        _day
    )

Please see the attached pbix.

Matrix headers - total and avg.pbix704 KB

MFelix

Super User

5 months ago

Hi PowerBI-P ,

This is related with the way that matrix work, when you place any value on the matrix this will be applied for all rows and for all columns and you are not able to hide it, you can turn on/off the totals but not the values so that Avg is repeated in all the columns.

For this you can try and use the calculation groups to get the correct values with a single metric in this case.

The best explanation I know is from parry2k .