Hi All, In our Tabular model we got Claim_Order fact & Payment fact table. Linking between 2 fact is by Claims dimension.
Relationship: 1 claim can have many Payments.
All was fine until we got a requirement in which we need to list down all Claim_order and if there is any payment show the payment related details.(left join in simple SQL from Claim to Payment)
So for example we got 100 claim_order and out of which only 50 has paid, then our report should show all 100 claims along with payments details. Payment details are coming from Payment Fact and related payment dimensions.
We use Paginated report to generate this reporting requirement but when we start adding fields related to payment, it auto filters claims that has only a payment present in the Payment fact.
Any solution for this ? Do we need dummy payment record for the claims which doesn't have a payment in the Payment fact or DAX can solve this issue?