Forum Discussion

felipeeduarte98's avatar
felipeeduarte98
New Member
1 year ago
Solved

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 column...
Need Help
  • FarhanJeelani's avatar
    FarhanJeelani
    1 year ago

    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.

FarhanJeelani's avatar
FarhanJeelani
Super User
1 year ago

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.