How to do it...

To complete this recipe, do the following:

  1. Create the following columns in the R02_Table table:
Y = SQRT(POWER(50,2) - POWER('R02_Table'[X],2))

A =
VAR __Table = ALL('R02_Table')
VAR __Max = MAXX(__Table,[X])
VAR __Min = MINX(__Table,[X])
VAR __Increment =
DIVIDE(
__Max - __Min + 1,
COUNTROWS(__Table)
)
RETURN
[Y]*__Increment
  1. Create the following measures:
AreaSemiCircle = PI()*POWER(50,2)/2

AreaApproximation =
VAR __Table = ALL('R02_Table')
VAR __Max = MAXX(__Table,[X])
VAR __Min = MINX(__Table,[X])
VAR __Increment =
DIVIDE(
__Max - __Min + 1,
COUNTROWS(__Table)
)
RETURN
ABS(
SUMX(
ADDCOLUMNS(
__Table,
"__Area",[Y]*__Increment
),
ABS([__Area])
)
)

% Error =
DIVIDE(
        [AreaApproximation] - [AreaSemiCircle],
[AreaSemiCircle]
)
  1. On a Report page, create a Line and clustered column chart visualization and place the X column from the R02_Table table into the Shared axis area.
  2. In the same Line and clustered column chart visualization, place the A column from the R02_Table table into the Column values area and the Y column from the R02_Table table into the Line values area.
  3. On the same Report page, create a Card visualization and place the AreaApproximation measure into the Fields area for the visual.
  4. On the same Report page, create a second Card visualization and place the AreaSemiCircle measure into the Fields area for the visual.
  5. On the same Report page, create a third Card visualization and place the % Error measure into the Fields area for the visual.