Forum Discussion

volt26's avatar
volt26
Icon for Helper I rankHelper I
2 years ago
Solved

Matrix visual with calculated columns : add an average column of the shown columns?

Hello!   I'm quite new to Power BI and I got almost everything I need from my visual but one thing : an average column of the shown columns. Here is what I have so far :     How can I achi...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi volt26 

     

    Sure, you can try this:

    MEASURE =
VAR _vtable =
    SUMMARIZE ( ALLSELECTED ( 'Table' ), 'Table'[ID], 'Table'[Num], "_AVG", [AVG] )
RETURN
    AVERAGEX ( _vtable, [_AVG] )

    The result is as follow:

     

    Best Regards

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

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi volt26 

 

Sure, you can try this:

MEASURE =
VAR _vtable =
    SUMMARIZE ( ALLSELECTED ( 'Table' ), 'Table'[ID], 'Table'[Num], "_AVG", [AVG] )
RETURN
    AVERAGEX ( _vtable, [_AVG] )

The result is as follow:

 

Best Regards

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

volt26's avatar
volt26
Icon for Helper I rankHelper I
2 years ago

Thank you very much for your help!