Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
AAbdelkader
Helper I
Helper I

inactive relationship Issue

‎09-21-2017 08:01 AM

hello there,

 

please, I need help as I got an issue which makes me upset, I've created a relationship between 2 table with another 2 common table as criteria. 

 

 

relationship

 

 

as you see it supposed to be an easy connection, but the Interval table is only connected to Adherence table but the CMS table is not

 

table

 

The file

 

gratefully,

 

Labels:
Message 1 of 3
1,233 Views
0
1 ACCEPTED SOLUTION
v-jiascu-msft
Microsoft Employee
Microsoft Employee

‎09-22-2017 12:01 AM

Hi @AAbdelkader,

 

The cause is the Intervals in CMS are different from the Itervals in Adherence. You can find it when you change the data type into "decimal".

 

inactive relationship Issue.jpg

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Best Regards!

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Message 2 of 3
1,463 Views
0
2 REPLIES 2
v-jiascu-msft
Microsoft Employee
Microsoft Employee

‎09-22-2017 12:01 AM

Hi @AAbdelkader,

 

The cause is the Intervals in CMS are different from the Itervals in Adherence. You can find it when you change the data type into "decimal".

 

inactive relationship Issue.jpg

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Best Regards!

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Message 2 of 3
1,464 Views
0
AAbdelkader
Helper I
Helper I
In response to v-jiascu-msft

‎09-23-2017 06:22 AM

@v-jiascu-msft, 

 

Yes yes, how couldn't I notice this?  I'll study the data source for Interval field again.

 

thanks a lot,

Message 3 of 3
1,207 Views
0

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

View All