Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
fatimaarshd
Helper I
Helper I

Forming relationship gives me blank

I have three similar tables. These tables contain different business logic though. I use each for a different purpose. The problem is that when I form a relationship of goals with sdp_patients3, values created by sdp_patients3 go blank. 

fatimaarshd_0-1697390349564.png

When I formed relationship from goals to sdp_patients2, values created by sdp_patients3 go blank. This is the DAX I use:

Weekly Active Patients =
CALCULATE(
DISTINCTCOUNT('SDP_Patients3'[RequestNumber]),
FILTER(
ALLSELECTED('SDP_Patients3'),
'SDP_Patients3'[Referral Created Week] <= SELECTEDVALUE(('Calendar'[End of Week])) &&
(
values 1
) &&
values 2
(
values3
) &&
(
'values4
) && values 5
)
) I am basically counting distinct patients when certain conditions in filter meets. All of these conditions are inside sdp_patients3. 

What could I be doing wrong?

 

Edit1:

I formed incorrect relationship. After forming correct relationship, it does give me values. But now instead of seeing 10k I am seeing 5k. I believe 5k patients are the ones that are present in Goals. How do I eradicate this?

1 REPLY 1
Greg_Deckler
Super User
Super User

@fatimaarshd Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.