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?

Ashish_Mathur's avatar
Ashish_Mathur
Super User
2 years ago

Hi,

You have to ensure that the fields which you rag to the row and columns of the matrix come from a third Dim table.  There should be a Many to One and Single relationship from the Actual/Budge tables to this third Dim Table.  Right now, it looks like the fields in your matrix are from the Actual table.

If this does not help, then share the download link of the PBI file.