Array Total Gives Incorrect Result for Rows and Columns

[Syndicate_Admin]

Good I have a matrix in which for the rows the client code is used (of the customer dimension) and for the columns, the type of product (of the dimension of products), for the values the distinctive count of the type of product is desired. The count is correct but the totals are not. The tables are not related to each other, only by the table in fact.

Would you know how to solve this problem?

[Syndicate_Admin]

They are columns of different tables. The relationship between the tables are as follows (the columns used in the matrix are in red):

And the data sample from both tables looks like this; on the one hand dim_producto and on the other dim_cliente:

Thanks from now!

[Anonymous]

Hi @Anonymous ,

Please forgive me for asking a few more questions.

What are your relationships in the data model?

Are the relationships as follows? Are the two relationships one-to-one, one-to-many or many-to-many?

And what does your TABLA_DE_HECHO look like?

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi @Anonymous ,

Are the values in your matrix a measure or a column?

If it's a measure, it is suggested to try creating a new measure like this:

New measure = SUMX('Table name', [Original measure])

or

New meausre =
VAR summarizedTable =
    SUMMARIZE (
        'Table',
        'Table'[Column1],
        'Table'[Column2],
        "Original measure", [Original measure]
    )
RETURN
    SUMX ( summarizedTable, [Original measure] )

If it's a column, I need some dummy data to reproduce, can you provide it?

Simliar blog: Power BI: Totals Incorrect and how to Fix it - Finance BI.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.