Forum Discussion

PowerBI-P's avatar
PowerBI-P
Frequent Visitor
6 months ago
Solved

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's avatar
    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.

     

v-hashadapu's avatar
v-hashadapu
Community Support
5 months ago

Hi PowerBI-P , Thank you for reaching out to the Microsoft Community Forum.

 

We find the answer shared by Natarajan_M & MFelix  is appropriate. Can you please confirm if the solution worked for you. It will help others with similar issues find the answer easily.

 

Thank you Natarajan_M & MFelix  for your valuable response.