Problem with dax and matrix visual

[rcardenasbc]

I have a problem with the Matrix visual, and that is that the budget value is repeated in each line and that does not happen with current
The dax of Actual is: Actual =
var Value = SUM(Sap[Actual])
Var Result = if(ISBLANK(Value),0,Value)
RETURN Result

The budget dax is:
Budget =
Var Value = SUM(Budget[Budget])
Var Result = if(ISBLANK(Value),0,Value)
RETURN Result
Both tables are unit by a master named GLALL
What should I do to correct the error, the visual image as an example, thanks for the help.

[rcardenasbc]

The relationship between the GLALL table and the Sap and Budget tables is one to many as shown, how could you create a measure to solve the problem, the GLALL table is a reference of the Sap table where the key is the GL and the department.

[hnguy71]

@rcardenasbc 

Can you show the relationship betwen GLALL and Budget?

[rcardenasbc]

Thanks Hnguy71, this is the relation ship between the tables

[hnguy71]

@rcardenasbc 
is presupuesto your budget table?

All your dimension attributes/fieldwell must come from the GLALL table. Can we double check that?

[rcardenasbc]

Yes Hnguy71, the presupuesto is my budget table; GLALL Table es the Main table, GLALL is obtain from Sap Table, look, thanks a lot

let
Source = Sap,
#"Removed Other Columns" = Table.SelectColumns(Source,{"GL", "Cost element descr.", "CO partner object name", "Cost Center"}),
#"Renamed Columns" = Table.RenameColumns(#"Removed Other Columns",{{"Cost element descr.", "Descripción"}, {"CO partner object name", "Department"}}),
#"Removed Duplicates" = Table.Distinct(#"Renamed Columns"),
#"Added Custom" = Table.AddColumn(#"Removed Duplicates", "GL-Descripción", each Number.ToText([GL]) & "-" & [Descripción]),
#"Changed Type" = Table.TransformColumnTypes(#"Added Custom1,{{"GL-Descripción", type text}, {"Group", type text}, {"Orden", Int64.Type}, {"Departamento", type text}, {"KeyGLDepart", type text}}),
#"Removed Duplicates1" = Table.Distinct(#"Changed Type", {"Departamento", "GL"})
in
#"Removed Duplicates1"

[hnguy71]

Hi @rcardenasbc 

Can you screenshot and hover on your fieldwell on your visual? All of them should be coming from the same GLALL table:

Here's an example of a screenshot (but yours should say GLALL instead):

[rcardenasbc]

Thanks Hnguy71, Here the information:

PREVIEW

[hnguy71]

hi @rcardenasbc ,

Your vendor/supplying plant and detail both needs to come from GLALL table. Since GLALL is a distinct/unique table using your SAP table as source, you should have both of those columns there as well.

Replace these two columns and your data should flow properly.

[Ashish_Mathur]

Hi,

You have to ensure that the fields which you rag to the row and columns of the matrix come from a third Dim table.  There should be a Many to One and Single relationship from the Actual/Budge tables to this third Dim Table.  Right now, it looks like the fields in your matrix are from the Actual table.

If this does not help, then share the download link of the PBI file.

[hnguy71 · Accepted solution]

Hi @rcardenasbc 

Repeated value likely is due to incorrect relationship with your master table and the budget table. Can you double check to make sure the relationship is corrected?