Measure to filter expression when relationship table has no value

Question

Hello,&nbsp;I have a measure calculating an integer from a date value in "Infinity" table. I only want it to do so when the "descriptors" table has no value based on the relationship between infinity and desicriptors. The measure returns all blank values even when there is a date value in the infinity column and a blank value in the descriptors column.&nbsp;&nbsp;Daily Release = CALCULATE( INT(CALCULATE(max(Infinity[Date Time]))), Descriptors[Descriptor]= BLANK())&nbsp;

mwegener · Answer

Hi&nbsp;Anonymous&nbsp;,
&nbsp;
avoid the many to many relationship and only filter in one direction.

&nbsp;

v-kelly-msft · Answer

Hi &nbsp;Anonymous ,&nbsp;As the 2 tables are many- many relationship,so when you wanna calculate a value based on the value from another table,if there're blank values in rows which have the same values in the related columns,it may return blank.Check the reference below which may help:https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-many-to-many-relationships&nbsp;&nbsp;Best Regards,KellyDid I answer your question? Mark my post as a solution!

Forum Discussion

Measure to filter expression when relationship table has no value

2 Replies

Related content

tool to find measures relationship

Relationship

Relationships

Relationship Issue

Creating relationships