To complete this recipe, do the following:
- Create the following measure:
While Loop =
VAR __i = 10
VAR __j = 0
VAR __loopTable =
ADDCOLUMNS(
GENERATESERIES(1,__i),
"__j",10,
"__i",[Value] - 1
)
RETURN
SUMX(
FILTER(__loopTable,[__i]>=1),
[__j]
)
- On a Report page, create a Card visualization and place the While Loop measureĀ into the Fields area