Measure to filter expression when relationship table has no value

[Anonymous]

Hello,

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. 

Daily Release = CALCULATE( INT(CALCULATE(max(Infinity[Date Time]))), Descriptors[Descriptor]= BLANK())

[v-kelly-msft]

Hi  @Anonymous ,

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

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[mwegener]

Hi @Anonymous ,

avoid the many to many relationship and only filter in one direction.