Forum Discussion
Helper IReincidente
Hi,sns1996 . I am glad to help you.
If you want to get the number of "YES" customers in your case, you can refer to my following test
Here is my test data:I created a couple of measures.
M_No_complaints_month = CALCULATE(DISTINCTCOUNT('Table'[Month_Num]),FILTER(ALL('Table'),'Table'[Cod Assinatura]=MAX('Table'[Cod Assinatura])))verification = IF([M_No_complaints_month]>=3,"Yes","No")M_num_of_Yes = CALCULATE( DISTINCTCOUNT('Table'[Cod Assinatura]),FILTER(ALL('Table'),[M_No_complaints_month]>=3))Total Individual Complaints = CALCULATE(SUM('Table'[No of complaints]),FILTER(ALL('Table'),'Table'[Cod Assinatura]=MAX('Table'[Cod Assinatura])))Here is the result:
I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,sns1996 .Thank you for your reply
You can share .pbix files to the forum by uploading them to OneDrive!
Hi,sns1996 . I am glad to help you.
If you want to get the number of "YES" customers in your case, you can refer to my following test
Here is my test data:
I created a couple of measures.
M_No_complaints_month =
CALCULATE(DISTINCTCOUNT('Table'[Month_Num]),FILTER(ALL('Table'),'Table'[Cod Assinatura]=MAX('Table'[Cod Assinatura])))verification = IF([M_No_complaints_month]>=3,"Yes","No")M_num_of_Yes =
CALCULATE(
DISTINCTCOUNT('Table'[Cod Assinatura]),FILTER(ALL('Table'),[M_No_complaints_month]>=3))Total Individual Complaints =
CALCULATE(SUM('Table'[No of complaints]),FILTER(ALL('Table'),'Table'[Cod Assinatura]=MAX('Table'[Cod Assinatura])))
Here is the result:
I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Helper IOi, Carson Jian. Obrigado pelo retorno.
Utilizei as medidas que voce me enviou mais não esta dando certo.
Estou anexando o arquivo que estou trabalhando para verificar onde estou errando.
Desde já agradeço.
Atenciosamente
Sérgio Nogueira
Hi,sns1996 .Thank you for your reply.
This may be due to the fact that the data I tested and your actual data do not match, and the calculation environment is different so that the code I provided does not achieve the correct effect.
You need to re-edit the code according to the field requirements in your actual case and the relationship before the table.
In my test data, the Data Bancas are Data/Time type data, the rest of the data is numeric or text type, but actually this does not affect the overall calculation logic!Unfortunately, I can't access the workspace report you provided due to my work environment, can you provide the pbix file that doesn't contain sensitive data (with simple test data in between, such as the case scenario you presented before)
Below is a screenshot when I try to access the link you provided:Please modify the code I provided according to your actual computing environment, if you can provide the corresponding pbix file (without sensitive data) and some data screenshots, it will be very helpful in solving your problem.
How to Get Your Question Answered Quickly - Microsoft Fabric Community
I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.