Forum Discussion
Matrix
I need help with a matrix in Power BI. I have two connected databases. One is a parent database, which has columns for ID, CONTRACT NAME, and ESTIMATED VALUE.
In the child database, there are columns for ID and MEASURED VALUE.
I created a one-to-many relationship (parent to child). However, the estimated value appears in the child database row when I place it in the matrix, as shown in the following image.
The lighter row contains information from the parent database, and the darker row contains information from the child database. Since there is no ESTIMATED VALUE in the child database, it is pulling this value from the parent database. Is there a way to leave it blank since this type of information does not exist?
Hi felipeeduarte98 ,
Yes, you can leave the ESTIMATED VALUE blank for the child rows in your Power BI matrix by using a conditional DAX measure.
Try DAX:
Estimated Value (Matrix) =
IF(
ISINSCOPE('ChildDatabase'[ID]), -- Checks if you are in the child level
BLANK(), -- Returns blank if in the child level
MAX('ParentDatabase'[Estimated Value]) -- Otherwise, returns the estimated value
)Please mark this post as solution if it helps you. Appreciate Kudos.
1 Reply
Hi felipeeduarte98 ,
Yes, you can leave the ESTIMATED VALUE blank for the child rows in your Power BI matrix by using a conditional DAX measure.
Try DAX:
Estimated Value (Matrix) =
IF(
ISINSCOPE('ChildDatabase'[ID]), -- Checks if you are in the child level
BLANK(), -- Returns blank if in the child level
MAX('ParentDatabase'[Estimated Value]) -- Otherwise, returns the estimated value
)Please mark this post as solution if it helps you. Appreciate Kudos.