Forum Discussion

Antonio_Gomez's avatar
Antonio_Gomez
Resolver I
3 years ago
Solved

Error adding (Sum) Columns or Rows

Hello Everyone,   I have this issue:   If I use this formula the total of the rows is OK, but the total of the columns is wrong:   PerDifAtendPersCorr = VAR _table = SUMMARIZE(Proyectos,Proy...
Need Help
Show and Tell
  • Antonio_Gomez's avatar
    Antonio_Gomez
    3 years ago

    foodd 

     

    I used this mesarure and the problem was solved

     

    PerDifAtendPersCorr = SUMX(Proyectos,[PerDifAtendPers] )

     

     

    Where:

     

    PerDifAtendPers = CALCULATE(
    DISTINCTCOUNT(AccionesIPI[IDSolicitante]),
    FILTER(
    AccionesIPI,
    OR(
    AccionesIPI[Medio] = "Presencial",
    AccionesIPI[Medio] = BLANK()
    )
    )
    )

     

     

Antonio_Gomez's avatar
Antonio_Gomez
Resolver I
3 years ago

foodd 

 

I could upload the file to Google Drive, but it has a lot of sensitive/personal data which is connected to the DB. So, I don't know how to give you the file taking the sensitive data out.

 

There is another way? Maybe with captures or explaining you the relationship, etc.

 

 

Antonio_Gomez's avatar
Antonio_Gomez
Resolver I
3 years ago

foodd 

 

I used this mesarure and the problem was solved

 

PerDifAtendPersCorr = SUMX(Proyectos,[PerDifAtendPers] )

 

 

Where:

 

PerDifAtendPers = CALCULATE(
DISTINCTCOUNT(AccionesIPI[IDSolicitante]),
FILTER(
AccionesIPI,
OR(
AccionesIPI[Medio] = "Presencial",
AccionesIPI[Medio] = BLANK()
)
)
)