Filtering on 3 Parameter in Paginated reports

Hi,Karolina411 .I am glad to help you.

According to your description, you are connecting a semantic model and querying the dataset using DAX code.

Your query:
Should I put the Year and Month fields in the PCPOrganization table?
Here is my suggestion.
For the DAX Query writing side
If the Year and Month fields are in the PCPOrganization table, it will be easier to filter the data because all the relevant filters are in the same table and it will make your DAX query writing easier (directly referencing the fields in the PCPOrganization table).

For data modeling
Putting the Year and Month fields in the PCPOrganization table simplifies the data model design and makes parameter filtering more intuitive and efficient.
Doing so also reduces the complexity of cross-table queries and improves query performance.

First question: With your current dax code, it seems that the existing parameters are not filtering the target results correctly.
My suggestion is to try to change the filtering order of the parameters and check the filters condition in DAX to make sure that the filtering range is correct for each variable.
Could you please try to do this using Dax Query Viusal in Power BI Desktop (open the relevant pbix file for this semantic model)

It's much easier to troubleshoot the code here and you can easily see the syntax errors, so you can try exporting each variable/filter table in the overall DAX code separately to see if it meets your expectations.

I think it's a good idea to have an additional dataset dedicated to these three parameters, which has a few advantages
Parameter Independence: Each parameter has its own dataset, which ensures the independence and accuracy of the parameter values.
Simplified filtering logic: with separate datasets, it's easier to manage and apply parameter filtering logic and avoid complex cross-table queries. Improve performance:
Setting up separate datasets at the same time can reduce the dependency between datasets and improve the query performance and the speed of generating paged reports.

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.