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

Question

Hi everyone,&nbsp;I have this model:&nbsp;A request can have 0 or 1 payments;Dimension_time is related to requests;Dimension_time (2) is related to payments.&nbsp;In the report, I just want to see request_id, creation date of the request (dimension_time -&gt; date) and, if exists, payment date (dimension_date 2 -&gt; date)..&nbsp;This is the result I see before I insert payment date in the report&nbsp;When I add payment date all published requests disappear:&nbsp;What I expected instead is seeing all requests with payment date NULL... What do I have to change?&nbsp;Thank you&nbsp;

aj1973 · Answer

Hi&nbsp;Simone2004&nbsp;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)&nbsp;

simone2004 · Answer

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

rourique · Answer

Research how to create power BI measures.the code is at the top of the screen and the measurements in the right corner.&nbsp;

simone2004 · Answer

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 · Answer

Simone2004&nbsp;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?&nbsp;

Forum Discussion

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

10 Replies

Related content

Creating relationships

Relationship

Create relationship dialog box

Relationship Issue

Relationships