Forum Discussion

brettg's avatar
brettg
Icon for Helper II rankHelper II
8 years ago

Use measure as value in visual e.g pie chart

Hi All,   Is it possible to use measures as values in visuals such as pie charts, scatter graphs..   I have created measures for the latest test and latest result of each user, and these update w...
Need Help
Greg1231's avatar
Greg1231
New Member
2 years ago

Hi, I'm having same problem any Idea how to solve this ? 
My measurment:

TotalSprintsMeasure =
VAR ActiveSprint =
    ADDCOLUMNS(
        ALL(SprintNames),
        "SprintEffort", SWITCH(
            TRUE(),
            [Sprint] = "1" && [1ActiveSprint] <> BLANK(), CALCULATE(SUM('RoT'[1SprintEffort]),'RoT'[Title] = SELECTEDVALUE('RoT'[Title]))
       
            // Add all other phase measures here
        )
    )
VAR FilteredSprint = FILTER(ActiveSprint, [SprintEffort] <> BLANK())
VAR TotalEffort = SUMX(FilteredSprint, [SprintEffort])
RETURN
    FORMAT(TotalEffort, "0.0")
In the table I get results but can't show that in PBI donut