Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
joaquinel
Helper I
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 ( VALUES(Personas[EsEmpleado]) , "False"),
    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 ( VALUES(Personas[EsEmpleado]) , "False"),
    FILTER(
        ServiciosContratables,
        ServiciosContratables[IdTipoServicio] = 5 || ServiciosContratables[IdTipoServicio] = 7
    ) 
)
)
formulacuenta.jpg
1 REPLY 1
Ahmedx
Super User
Super User

write another measure like this

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

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.