Forum Discussion
Problem with dax and matrix visual
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?
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.
Can you show the relationship betwen GLALL and Budget?
Thanks Hnguy71, this is the relation ship between the tables
rcardenasbc
is presupuesto your budget table?All your dimension attributes/fieldwell must come from the GLALL table. Can we double check that?
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"