Forum Discussion

cruzp's avatar
cruzp
Icon for Helper V rankHelper V
3 years ago

Table shows all rows when measure is added

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 DA...
Need Help
pankaj_lp's avatar
pankaj_lp
Icon for Helper I rankHelper I
3 years ago

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's avatar
    cruzp
    Icon for Helper V rankHelper V
    3 years ago

    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.