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 I

## Wrong column totals in a matrix

Hi, I have a problem with a formula when using matrix. I have use two ways but no one is perfect. I need you to help me to mix two formules. If I use de Formule1 I get the result I want, but the column total is wrong, but if I use the second formula I don't have the desired result but the total is correct. How should I mix this two formules? thanks

Fórmula1

CALCULATE
(
DISTINCTCOUNT
(
Pagos[IdPersonaOrigen]
)
,
USERELATIONSHIP(
'1CalFCreacion'[Date]
,
ContratosServicio[FechaAlta]
)
,
USERELATIONSHIP(
Pagos[IdPersonaOrigen]
,
ContratosServicio[IdUsuario]
)
,
Pagos[CuentaContable] = "70510030"
,
FILTER(
ServiciosContratables,
ServiciosContratables[IdTipoServicio] = 5 || ServiciosContratables[IdTipoServicio] = 7
)
)

Fórmula2

COUNTX
(
Pagos
,
CALCULATE
(DISTINCTCOUNT(Pagos[IdPersonaOrigen])
,
USERELATIONSHIP(
'1CalFCreacion'[Date]
,
ContratosServicio[FechaAlta]
)
,
USERELATIONSHIP(
Pagos[IdPersonaOrigen]
,
ContratosServicio[IdUsuario]
)
,
Pagos[CuentaContable] = "70510030"
,
FILTER(
ServiciosContratables,
ServiciosContratables[IdTipoServicio] = 5 || ServiciosContratables[IdTipoServicio] = 7
)
)
)
Super User

write another measure like this

``Fórmula1 fixed = SUMX(VALUES('Date'[Day]),[Fórmula1]) ``

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