cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper II

## Problem with division

Good Morning,
Guys I'm trying to do a division, but the result is not correct. Can anyone help me?

% de conversão em vendas = DIVIDE(([Total de pedidos faturados]),([Total de cotações digitadas]))

Total de cotações digitadas = COUNT(PEDIDO_VENDA[NS_CODIGO])
Total de pedidos faturados = COUNT(NF_SAIDA[NS_CODIGO])

The result should be 83.84% and not 84.48%

1 ACCEPTED SOLUTION
Super User

One possible issue could be that the COUNT function is counting duplicate values in either the PEDIDO_VENDA or NF_SAIDA table. To fix this, you can try using the DISTINCTCOUNT function instead of COUNT. This will only count unique values in the table.

Another possible issue could be that the PEDIDO_VENDA and NF_SAIDA tables have different filters applied, resulting in a different count for each table. To fix this, you can try applying the same filters to both tables before performing the division.

Lastly, you can check for any hidden filters that may be affecting the data.

Try the following:

% de conversão em vendas = DIVIDE(DISTINCTCOUNT(NF_SAIDA[NS_CODIGO]), DISTINCTCOUNT(PEDIDO_VENDA[NS_CODIGO]))

If the above still does not work, please provide more details about your data and the filters applied to the tables.

3 REPLIES 3
Helper II

I managed to solve it here. The filters were different. Thank you very much

Super User

One possible issue could be that the COUNT function is counting duplicate values in either the PEDIDO_VENDA or NF_SAIDA table. To fix this, you can try using the DISTINCTCOUNT function instead of COUNT. This will only count unique values in the table.

Another possible issue could be that the PEDIDO_VENDA and NF_SAIDA tables have different filters applied, resulting in a different count for each table. To fix this, you can try applying the same filters to both tables before performing the division.

Lastly, you can check for any hidden filters that may be affecting the data.

Try the following:

% de conversão em vendas = DIVIDE(DISTINCTCOUNT(NF_SAIDA[NS_CODIGO]), DISTINCTCOUNT(PEDIDO_VENDA[NS_CODIGO]))

If the above still does not work, please provide more details about your data and the filters applied to the tables.

Super User

It seems your tables are related, try like:

% de conversão em vendas =
DIVIDE(
(CALCULATE ( [Total de pedidos faturados], ALL(PEDIDO_VENDA)),
(CALCULATE ( [Total de cotações digitadas], ALL(NF_SAIDA))
)

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors