Add descriptive Statistical measures

Anonymous ,

Firstly, in query editor, click unpivot columns, then you will achieve the Attribute and Value columns. After applied&close, create three measures using dax below:

Average = CALCULATE(AVERAGE('Table'[Value]), ALLEXCEPT('Table', 'Table'[Attribute]))
Median = CALCULATE(MEDIAN('Table'[Value]), ALLEXCEPT('Table', 'Table'[Attribute]))
1st Quartile = CALCULATE(PERCENTILE.EXC('Table'[Value], 0.25), ALLEXCEPT('Table', 'Table'[Attribute]))

The result will be like below:

You can also refer to the pbix file.

Community Support Team _ Jimmy Tao

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

I Used below solution and that helped :

Built the measures needed and put them in the ‘values’ on the matrix along with the date in the ‘columns’. Then selected the setting called ‘Show on rows’ in the values settings on the matrix.