Forum Discussion

Frequent Visitor

2 years ago

Solved

measure dax %

Hola, tengo una medida que no puedo generar hace dias, resulta que tengo mi tabla llamada TABLA, dentro tengo varias columnas, una de esas es "Número de documento" y otra llamada "IRA", el numero de ...

Need Help

Tutorial Requests

Anonymous
2 years ago
Hi Jhophshepht

To make the total correct, you may create a new measure:

Measure = AVERAGEX(VALUES('Table'[Número de documento]),[IRA Value])

[IRA Value] is the old measure:

IRA Value = MAX('Table'[IRA])

The "incorrect total" behavior is common in table/matrix visuals in Power BI, you can refer to the following blogs about how to deal with it. This occurs because Power BI intends to calculate the total based on rows of underlying data instead of the rows displayed in the visual.

Why Power BI totals might seem inaccurate - SQLBI

Obtaining accurate totals in DAX - SQLBI

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!

Anonymous

Not applicable

2 years ago

Hi Jhophshepht

To make the total correct, you may create a new measure:

Measure = AVERAGEX(VALUES('Table'[Número de documento]),[IRA Value])

[IRA Value] is the old measure:

IRA Value = MAX('Table'[IRA])

The "incorrect total" behavior is common in table/matrix visuals in Power BI, you can refer to the following blogs about how to deal with it. This occurs because Power BI intends to calculate the total based on rows of underlying data instead of the rows displayed in the visual.

Why Power BI totals might seem inaccurate - SQLBI

Obtaining accurate totals in DAX - SQLBI

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!