Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

DAX Formula and Measure Question

Hello everyone! My data is depicted below (1st picture). It is pretty simple, I created the Total Subtasks Completed and the % of PP Progress columns. The total subtasks completed is the sum of the a...
Need Help
question
Show & Tell
  • FreemanZ's avatar
    FreemanZ
    3 years ago
    Supposing your table named Data, try to add a column with the code below:
    PctRange =
    SWITCH(
        TRUE(),
        Data[% of PP Progress] <=0.25, "0-25%",
        Data[% of PP Progress] <=0.5, "26%-50%",
        Data[% of PP Progress] <=0.75, "51%-75%",
        "76%-100%"
    )
Anonymous's avatar
Anonymous
Not applicable
3 years ago

I got this error when I tried it <ccon>A circular dependency was detected: PP-Task Completion[% of PP Progress], PP-Task Completion[PctRange], PP-Task Completion[% of PP Progress].</ccon>

FreemanZ's avatar
FreemanZ
Icon for Super User rankSuper User
3 years ago
Rewrite your column as below:
% of PP Progress =
CALCULATE(
    DIVIDE(Data[Total Subtasks completed],17),
    ALLEXCEPT (Data[Total Subtasks completed])
)