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

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.