To observe how different lines can give different values for skewness, do the following:
- Create the following measures:
09_Skewness2 =
VAR __Table = SELECTCOLUMNS('R09_Table',"__Value",'R09_Table'[Column2])
RETURN
DIVIDE(
3 * (AVERAGEX(__Table,[__Value]) - MEDIANX(__Table,[__Value])),
STDEVX.P(__Table,[__Value]),
0
)
09_Skewness3 =
VAR __Table = SELECTCOLUMNS('R09_Table',"__Value",'R09_Table'[Column3])
RETURN
DIVIDE(
3 * (AVERAGEX(__Table,[__Value]) - MEDIANX(__Table,[__Value])),
STDEVX.P(__Table,[__Value]),
0
)
- On the same Report page as before, create another Card visualization and place the 09_Skewness2 measure into the Fields area of the visualization.
- On the same Report page, create another Card visualization and place the 09_Skewness3 measure into the Fields area of the visualization.
- On the same Report page, create another Line chart visualization and place the Index column from the R09_Table table into the Axis area and the Column2 column from the R09_Table table into the Values area of the visualization.
- On the same Report page, create another Line chart visualization and place the Index column from the R09_Table table into the Axis area and the Column3 column from the R09_Table table into the Values area of the visualization.