Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Vote for your favorite vizzies from the Power BI Dataviz World Championship submissions. Vote now!
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.
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?
@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.
Vote for your favorite vizzies from the Power BI World Championship submissions!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Check out the January 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 64 | |
| 51 | |
| 46 | |
| 23 | |
| 19 |
| User | Count |
|---|---|
| 136 | |
| 110 | |
| 50 | |
| 32 | |
| 29 |