Forum Discussion

Frequent Visitor

2 years ago

Solved

Problem with dax and matrix visual

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])...

Tips and Tricks

hnguy71
2 years ago
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?

Super User

2 years ago

Can you show the relationship betwen GLALL and Budget?

Frequent Visitor

2 years ago

Thanks Hnguy71, this is the relation ship between the tables

hnguy71
Super User
2 years ago
rcardenasbc
is presupuesto your budget table?

All your dimension attributes/fieldwell must come from the GLALL table. Can we double check that?
- rcardenasbc
  Frequent Visitor
  2 years ago
  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
    Super User
    2 years ago
    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):