Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi Experts
When using the day_date column asa filter in my Power BI i am unable to filter the number of consent in my matrix table based on Product. Product is in Dev_con_hcp_universe.
02 | Calendar Table link to Dev_con_consent via Day_id to Capture_day_id
Dev-con_consent links to Dev_con_hcp_universe via Crmf_hcp_id to Crrmf_hcp_id (many-to-many)
Cannot see my error.
my DAX measure is
Solved! Go to Solution.
Hi @Invesco
What is the cross-filter direction between Dev-con_consent and Dev_con_hcp_universe? For a many-to-many relationship, it will be Both by default. But since your Product is in Dev_con_hcp_universe and you want to use Product to filter Dev-con_consent table, you can modify its cross-filter direction to Single (Dev_con_hcp_universe filters Dev-con_consent). This may make a difference.
Model relationships in Power BI Desktop - Power BI | Microsoft Learn
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
Hi @Invesco
What is the cross-filter direction between Dev-con_consent and Dev_con_hcp_universe? For a many-to-many relationship, it will be Both by default. But since your Product is in Dev_con_hcp_universe and you want to use Product to filter Dev-con_consent table, you can modify its cross-filter direction to Single (Dev_con_hcp_universe filters Dev-con_consent). This may make a difference.
Model relationships in Power BI Desktop - Power BI | Microsoft Learn
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
User | Count |
---|---|
80 | |
74 | |
63 | |
61 | |
45 |
User | Count |
---|---|
108 | |
98 | |
89 | |
82 | |
61 |