UseRelationship Not Working

Hi ,

I have the below model on Tabular Model where the date is linked to the Date closed in the claim policy.

however, when i try to browse using the month, i get nothing in the months

First of all, i am filtering to where claims is Property ( using one of the videos )

Property Applications:= CALCULATE(COUNTROWS(ClaimsPolicy),ClaimsPolicy[Line of Business] ="Commercial Property")

and 

Applications by Closed Date:=CALCULATE([Property Applications] , USERELATIONSHIP('Date'[Date],ClaimsPolicy[Date Closed]))

Then nothing happens when i drag the month to it, is there something i am doing wrong

image

image

1 Like

Hello,

Everything looks good from the pictures you attached, but in cases like this you need to upload a sample PBIX file so we can determine what else is going on.

Thanks
Jarrett

Hello @alora101,

The measure seems correct but you are checking the end result WITHOUT a filter context.
When Analyze in Excel try using in the Pivot table the weeks on rows and the measures in the values and see whether you have the same result.
Before that just make sure the “Date Closed” column type is Date exactly like the the Date[Date] column type.

If you liked my solution please give it a thumbs up :+1:.

If I did answer your question please mark my post as a solution :white_check_mark:.

Thank you !

Cristian

Hi All,

I am building this in TABULAR MODEL ANALYSIS SERVICES and not power BI MODEL.

i have the correct data type but still dont know what else to do.

@Christian. I have done that still getting same result

I would try to build another test Model just with the Date and Claim tables, re-do the measures and test again there.

Cristian

Just did and still same.

Sorry to hear that :frowning:
Next step I would do a sample model in PBI just to test it … and if it wouldn’t work either I would go to a consultant.

This article and video has been posted by Alberto on sqlbi.com

It may help with your situation

Guy