Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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
Hi @Anonymous ,
avoid the many to many relationship and only filter in one direction.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
117 | |
107 | |
70 | |
70 | |
43 |
User | Count |
---|---|
148 | |
106 | |
104 | |
89 | |
65 |