Skip to main content
cancel
Showing results for 
Search instead 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

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
Europe Fabric Conference

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.

AugPowerBI_Carousel

Power BI Monthly Update - August 2024

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

August Carousel

Fabric Community Update - August 2024

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