Hi,Brightsider

Regarding the issue you raised, my solution is as follows:

Sorry for being late, but has your problem been solved? If it does, share your solution and accept it as a solution, which will help members of the community who share your problem find a solution faster.

Here are the solutions we offer:

1.According to your requirements, we infer that the reason for this is that the relationship was not established correctly when you established the table relationship. You can try to re-establish the table relationship. Here is the relevant documentation:
Create and manage relationships in Power BI Desktop - Power BI | Microsoft Learn

2.Of course you can also use the ISINSCOPE() function, here are the relevant use cases:

Measure = 
IF(ISINSCOPE(financials[Product]),"second",IF(ISINSCOPE('financials'[Country]),"fisrt"))

ISINSCOPE function (DAX) - DAX | Microsoft Learn

3.Here are some relevant documents to help you:

Create a matrix visual in Power BI - Power BI | Microsoft Learn

According to the data you provided, we cannot provide you with a complete solution for the time being, especially for the part of table relationship. We hope that you can provide a complete pbix file with sensitive information removed, which will help us analyze the reason for you better.

Please find the attached pbix relevant to the case.

Best Regards,

Leroy Lu

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

Forum Discussion

Pipeline parameters passing to Dataflows Gen 2 parameter values

Parameter in summarize

notebook parameter

Parameters to fabric pipeline

dataflow gen2 parameters

Field Parameter Question