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

[Simone2004]

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 see request_id, creation date of the request (dimension_time -> date) and, if exists, payment date (dimension_date 2 -> date)..

This is the result I see before I insert payment date in the report

When I add payment date all published requests disappear:

What I expected instead is seeing all requests with payment date NULL... What do I have to change?

Thank you

[Simone2004]

I cannot believe, a thing simple like this is so difficult in power bi 😥

[v-kkf-msft]

Hi @Simone2004 ,

I used the same model to create sample data, and I was able to get the payment date for all request_id.

You can see the difference between my model and yours. If possible, could you please share your PBIX file without sensitive data? 

Best Regards,
Winniz

[aj1973]

Hi @Simone2004 

You can't just insert the Payement date in the visual, you need to create a measure that will bring and insert that date into the visual. Use CALCULATE(SELECTEDVALUE( the date here), USERELATIONSHIP(column date from dimension_time , column payement date key from payments fact table)

[Simone2004]

where do I have to create the measure column? In the requests fact table?  Dont I have to use a relationship between requests and payments by request_id?

[rourique]

Research how to create power BI measures.

the code is at the top of the screen and the measurements in the right corner.

[Simone2004]

yes, but to create a Measure I must select a table... Which table do I must select?

• The payments fact, make no sense I suppose;
• The requests fact, I suppose I must create a relation between requests fact and payments fact in the DAX Function... no?

[aj1973]

@Simone2004 

Why do you need to add a column, you just need to create a measure to call the date of payments and then add that measure to your visual.

Did you try the measure I asked you to add?

[Simone2004]

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]

Replace that by 

by

and try again

[Simone2004]

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?