Forum Discussion
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 is not present, the values are showing up the same across the week. Could someone help me figure out how to solve this issue? Thanks for help.
https://drive.google.com/file/d/1NuQoyVaQTG4nXPZOGSmB_HXTfMoBmiPS/view?usp=sharing
Hi,
I removed the agent_id from rows of the table and i still see different quartiles. What is the problem?
8 Replies
andrelopes2711 The overall problem that I perceive here is that the TB_Quartil is not related to anything. This is not necessarily an issue but then you need to form the relationship within the measure itself and that is not being done either. It's difficult to understand how to fix the issue necessarily given that I am unsure of what you would like the results to be. In general, you would have to create a table within your measure, add a column to it using your quartile classification measure, get the max quartil from TB_Quartil table and then filter that table down and do some kind of aggregation. That's the general steps that I can more or less deduce from your file and explanation but not really able to proceed further without additional information.
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.
Hi,
I removed the agent_id from rows of the table and i still see different quartiles. What is the problem?
Thank you for submitting your question to the Microsoft Fabric Community Forum, and thanks to GeraldGEmerick and Ashish_Mathur for offering helpful suggestions.
Could you let us know if the suggested solution resolved your issue? This information can assist other community members facing similar challenges.
Thank you.
Hi andrelopes2711
We wanted to check if you’ve had a chance to review the information provided. If you have any further questions, please let us know. Has your issue been resolved? If not, please share more details so we can assist you further.
Thank You.We have not yet received a response regarding your query. Could you please confirm if your issue has been resolved? If not, kindly provide additional details so we can offer further assistance.
Thank you
