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?

rcardenasbc's avatar
rcardenasbc
Frequent Visitor
2 years ago

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's avatar
    hnguy71
    Super User
    2 years ago

    rcardenasbc 

    Can you show the relationship betwen GLALL and Budget?

    • rcardenasbc's avatar
      rcardenasbc
      Frequent Visitor
      2 years ago

      Thanks Hnguy71, this is the relation ship between the tables

       

       

      • 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?