Need Help: Quartile Measure Shows Same Values Across Week Without Agent_ID

[andrelopes2711]

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 

[v-karpurapud]

Hi @andrelopes2711 

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

[v-karpurapud]

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.

[v-karpurapud]

Hi @andrelopes2711 

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.

[Ashish_Mathur · Accepted solution]

Hi,

I removed the agent_id from rows of the table and i still see different quartiles.  What is the problem?

[GeraldGEmerick]

@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.

[andrelopes2711]

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?

[GeraldGEmerick]

@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
    _result

Again, I sincerely apologize regarding my lack of ability to understand your predicament clearly.

[andrelopes2711]

 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. 😊