Forum Discussion

Simone2004's avatar
Simone2004
Icon for Helper I rankHelper I
5 years ago

How to create a 0...1/Many relationship

Hi everyone,   I have this model:   A request can have 0 or 1 payments; Dimension_time is related to requests; Dimension_time (2) is related to payments.   In the report, I just want to...
Need Help
Simone2004's avatar
Simone2004
Icon for Helper I rankHelper I
5 years ago

I am sorry but I do not understand what you mean... 

I do not want to create a column, but honestly I do not know how to create a Measure is not related to a table....

 

However.... I have tried something...

 

If I click on "New Measure" on the top, Power BI automaticallycreate the measure in the Payments Fact table.. and the result is an empty table:

 

If I create a measure selecting the Requests Fact table 

 

I get always an empty table

 

 

In both case, the measure is this:

 

aj1973's avatar
aj1973
Icon for Community Champion rankCommunity Champion
5 years ago

Replace that by 

by

and try again

 

  • Simone2004's avatar
    Simone2004
    Icon for Helper I rankHelper I
    5 years ago

    It seems it does not work... just infinite loading and empty visual... 

    It could be because the registry_time table has already an active relation with the creation_date?