Forum Discussion
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])
Var Result = if(ISBLANK(Value),0,Value)
RETURN Result
The budget dax is:
Budget =
Var Value = SUM(Budget[Budget])
Var Result = if(ISBLANK(Value),0,Value)
RETURN Result
Both tables are unit by a master named GLALL
What should I do to correct the error, the visual image as an example, thanks for the help.
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?
10 Replies
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?
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.
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.
Can you show the relationship betwen GLALL and Budget?
Thanks Hnguy71, this is the relation ship between the tables
