How to do it...

To complete this recipe, do the following:

  1. Create the following measures:
Kn = COUNTROWS(ALL('R07_Table'))

Kmean = AVERAGEX(ALL('R07_Table'),'R07_Table'[Values])

KStdDev = STDEVX.S(ALL('R07_Table'),'R07_Table'[Values])

Skewness =
VAR __Mean = [Kmean]
VAR __StdDev = [KStdDev]
VAR __n = [Kn]
VAR __Table =
ADDCOLUMNS(
'R07_Table',
"__Skew",POWER(('R07_Table'[Values]-__Mean),3)
)
RETURN
DIVIDE(
SUMX(__Table,[__Skew]),
POWER(__StdDev,3),
0
) * DIVIDE(1,__n,0)

Kurtosis =
VAR __Mean = [Kmean]
VAR __StdDev = [KStdDev]
VAR __n = [Kn]
VAR __Table =
ADDCOLUMNS(
'R07_Table',
"__Skew",POWER(('R07_Table'[Values]-__Mean),4)
)
RETURN
DIVIDE(
SUMX(__Table,[__Skew]),
POWER(__StdDev,4),
0
) * DIVIDE(1,__n,0)

Excess Kurtosis = [Kurtosis] - 3

Kurtosis Type =
SWITCH(TRUE(),
[Excess Kurtosis]>0,"Leptokurtic",
[Excess Kurtosis]<0,"Platykurtic",
"Mesokurtic"
)
  1. On the same Report page, create a Card visualization and place the Kn measure into the Fields area of the visualization.
  2. On the same Report page, create another Card visualization and place the Kmean measure into the Fields area of the visualization.
  3. On the same Report page, create another Card visualization and place the KStdDev measure into the Fields area of the visualization.
  4. On the same Report page, create another Card visualization and place the Skewness measure into the Fields area of the visualization.
  5. On the same Report page, create another Card visualization and place the Kurtosis measure into the Fields area of the visualization.
  6. On the same Report page, create another Card visualization and place the Excess Kurtosis measure into the Fields area of the visualization.
  7. On the same Report page, create another Card visualization and place the Kurtosis Type measure into the Fields area of the visualization.
  8. On the same Report page, create a Line chart visualization and place the Index column from the R07_Table table into the Axis area and the Values column from the R07_Table table into the Values area of the visualization.