Hi Community,
I have following two tables, relationship from Log to Data is Many to one.
Log:
Data:
I want to create a measure (not column) in either of the tables, that picks the corresponding date of an ID that has new Value = Pass, else blank.
Here is the sample pbi file: Test measure.pbix
Hi,
I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.
expected result measure: =
VAR _condition =
COUNTROWS ( FILTER ( 'Log', 'Log'[new value] = "Pass" ) ) <> 0
RETURN
IF ( _condition && HASONEVALUE ( Data[ID] ), "Pass" )
Hi,
I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.
expected result measure: =
VAR _condition =
COUNTROWS ( FILTER ( 'Log', 'Log'[new value] = "Pass" ) ) <> 0
RETURN
IF ( _condition && HASONEVALUE ( Data[ID] ), "Pass" )
Helpful resources
New to Fabric Survey
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
Power BI DataViz World Championships - June 2026
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Power BI Community Update - March 2026
Check out the March 2026 Power BI update to learn about new features.
