Forum Discussion
Solved
Need Help: Quartile Measure Shows Same Values Across Week Without Agent_ID
I created a quartile classification measure, and in the matriz table by agent_id it's returning the correct classification. However, in the table where the classification is in the rows and agent_id ...
Hi,
I removed the agent_id from rows of the table and i still see different quartiles. What is the problem?
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. 😊