topic Re: Reincidente in DAX Commands and Tips

Reincidente

sns1996 — Tue, 09 Jul 2024 18:59:59 GMT

Boa tarde,

Estou precisando de uma ajuda no cálculo abaixo:

Na base em anexo eu preciso calcular o total de reincidente, conforme regras abaixo:

1 - Calcular quantas vezes o cod assinatura se repetiu em, por exemplo, o

Cod Assinatura "24539774" repetiu 3 vez (janeiro, março e maio)

Cod Assinatura "25879994" repetiu 1 vez (maio)

Cod Assinatura "90988234" repetiu 1 vez (janeiro, fevereiro, março e abril)

2 – Se a quantidade de vezes que se repetiu foi maior ou igual a 3 é uma assinatura reincidente.

3 – Quantas assinaturas foram reincidentes, no exemplo acima o meu total é igual a 2.

Re: Reincidente

Anonymous — Wed, 10 Jul 2024 01:59:22 GMT

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.

Re: Reincidente

sns1996 — Wed, 10 Jul 2024 17:23:04 GMT

Oi, 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

https://app.powerbi.com/reportEmbed?reportId=a16e90a3-f38f-46bf-8918-d131f36585c2&autoAuth=true&ctid=0b057354-0fc9-47e5-8674-8449dd7e88b8

Re: Reincidente

Anonymous — Thu, 11 Jul 2024 02:38:29 GMT

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.

Re: Reincidente

sns1996 — Thu, 11 Jul 2024 11:29:45 GMT

Bom dia, Carson Jian,

Não estou conseguindo anexo o arquivo pbix, só encontrei a opção de anexar o link.

Você pode me ajudar como anexar.

Atenciosamente,

Sérgio Nogueira

Re: Reincidente

Anonymous — Fri, 12 Jul 2024 02:16:11 GMT

Hi,sns1996 .Thank you for your reply
You can share .pbix files to the forum by uploading them to OneDrive!