topic Re: DAX Formula and Measure Question in DAX Commands and Tips

DAX Formula and Measure Question

Anonymous — Tue, 15 Nov 2022 17:04:19 GMT

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 all the different subtask result columns, and the % of PP progress uses the values in the Total Subtasks completed columns divided by 17 because thats how many different subtasks there are. On the second picture I attached, I made a quick table visual which shows how many subtasks and their % of PP progress a person has. I was looking to create a measure or column which can bucket the % of PP Progress into a 25% bucket. Such as those between 0 and 25% are in 1, 26-50% in another, 51-75% in a third, and lastly 76-100%. Is there a DAX Calculation I can use to make this successful?

Re: DAX Formula and Measure Question

Syk — Tue, 15 Nov 2022 17:16:02 GMT

You can group your data without DAX! Click the column you're wanting to group and under column tools > data groups > New data groups

Then you can toss those %s in buckets

Re: DAX Formula and Measure Question

Anonymous — Tue, 15 Nov 2022 20:37:08 GMT

I never knew this! When I tried to do it, I got this popup which I've never seen before.

Re: DAX Formula and Measure Question

FreemanZ — Tue, 15 Nov 2022 21:32:48 GMT

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%"

)

Re: DAX Formula and Measure Question

Anonymous — Tue, 15 Nov 2022 21:35:54 GMT

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>

Re: DAX Formula and Measure Question

FreemanZ — Tue, 15 Nov 2022 22:05:30 GMT

Rewrite your column as below:

% of PP Progress =

CALCULATE(

DIVIDE(Data[Total Subtasks completed],17),

ALLEXCEPT (Data[Total Subtasks completed])

)

Re: DAX Formula and Measure Question

Anonymous — Fri, 02 Dec 2022 07:18:47 GMT

Hi Anonymous ,

Try a measure like below:

Measure = var %Progress = sum([% of PP Progress]) Return SWITCH( TRUE(), %Progress <= 0.25, 1, %Progress > 0.25 && %Progress < = 0.5, 2, %Progress > 0.5 && %Progress <=0.75, 3, 4 )