To complete this recipe, do the following:
- 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"
)
- On the same Report page, create a Card visualization and place the Kn measure into the Fields area of the visualization.
- On the same Report page, create another Card visualization and place the Kmean measure into the Fields area of the visualization.
- On the same Report page, create another Card visualization and place the KStdDev measure into the Fields area of the visualization.
- On the same Report page, create another Card visualization and place the Skewness measure into the Fields area of the visualization.
- On the same Report page, create another Card visualization and place the Kurtosis measure into the Fields area of the visualization.
- On the same Report page, create another Card visualization and place the Excess Kurtosis measure into the Fields area of the visualization.
- On the same Report page, create another Card visualization and place the Kurtosis Type measure into the Fields area of the visualization.
- 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.