DAX measure impacting relationship

[jkapso751]

Hi all,

I'm a newbie at DAX looking for some help.  I have two simple tables: one dimension (Product/Cluster) and one fact (Product/Revenue/Profit).  I've created a relationship between the product columns in both tables.

In the pivot you may be able to see that I'm aggregating by "Cluster."  I want to create a measure that will flag rows in the pivot with zero revenue.  For some reason using an "if" statement seems to unravel the relationship between product and cluster:

Is there a way that I can do this using DAX without impacting the relationship?  Many thanks and I appreciate any help I can get!!

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.