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%"
    )
FreemanZ's avatar
FreemanZ
Super User
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
    Super User
    3 years ago
    Rewrite your column as below:
    % of PP Progress =
    CALCULATE(
        DIVIDE(Data[Total Subtasks completed],17),
        ALLEXCEPT (Data[Total Subtasks completed])
    )