Forum Discussion
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...
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)
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?
Research how to create power BI measures.
the code is at the top of the screen and the measurements in the right corner.
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?
