Forum Discussion

rcardenasbc's avatar
rcardenasbc
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])...
Need Help
Show and Tell
Tips and Tricks
  • hnguy71's avatar
    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?

hnguy71's avatar
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's avatar
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's avatar
    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):

     

    • rcardenasbc's avatar
      rcardenasbc
      Frequent Visitor
      2 years ago

      Thanks Hnguy71, Here the information:

       

       

      PREVIEW
       
       
       
      • hnguy71's avatar
        hnguy71
        Super User
        2 years ago

        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.