Table shows all rows when measure is added

[cruzp]

Hi 

I want to create a new field that will show True if StartPrevious is Null/Empty. As seen in the picture below:

1 Opportunity have 1 project 

Expected output:

I am using this DAX Formula: 

StartDateBool = IF(ISBLANK([StartPrevious]),"True","False")
But I am not getting the expected output as shown the above pic since the rows automatically expands and shows a lot of rows even when the opportunity should only have 1 project. 

My model has one to many relationship between fact-aging.

Please help.

[pankaj_lp]

if its possible could you share a sample data

[pankaj_lp]

it seems its because of the relationship between the tables,
Try using this anyway:

StartDateBool =
VAR OpportunityID = [Opportunity_BK]
VAR HasProject =
CALCULATE(
COUNTROWS(Table),
FILTER(
Table,
Table[Opportunity_BK] = OpportunityID &&
NOT(ISBLANK(Table[StartPrevious]))
)
)
RETURN
IF(HasProject > 0, "False", "True")

[cruzp]

Hi @pankaj_lp I can't call the [Opportunity_BK] from the DIM_Opportunity table although there is a one to many relationship to my fact table.