Forum Discussion
Need Help: Quartile Measure Shows Same Values Across Week Without Agent_ID
Hi,
I removed the agent_id from rows of the table and i still see different quartiles. What is the problem?
Hi GeraldGEmerick , for example, the measure selected in the filter and in the week, would be classified by quartile, but understanding what you meant, I would need to count the employee IDs and for each measure I would classify the IDs and the values of the measure, for it to work, any ideas to do this if it is the right thing to do?
andrelopes2711 While I am quite certain that this is not the correct solution that you are looking for, this is something along the lines of what I was trying to convey in my earlier message:
Measure =
VAR _result =
COUNTROWS(
FILTER(
SUMMARIZECOLUMNS(
dCCC[AGENT_WORKDAY1],
"_Classificação Quartil", [Classificação Quartil]
),
[_Classificação Quartil] = MAX( TB_Quartil[Quartil] )
)
)
RETURN
_resultAgain, I sincerely apologize regarding my lack of ability to understand your predicament clearly.
In this table, I need a view where I select the measure in the filter and it classifies the quartiles. The way it is now, all the values are the same from Q1 to Q4 in each week. I hope I’ve explained it better this time. 😊