Filtering on 3 Parameter in Paginated reports

Question

&nbsp;&nbsp;I am working on a Paginated report that the user would like toSelect date (Month/Year) then the Physician organization then the pcp location to have a pdf for that location only. Below the Physician Organization does not filter on the PCP Location.Dataset1&nbsp;will be filtered by Physician Organization, PCPlocation &nbsp;and Date (monthly reporting) and&nbsp;Physician Location which has the &nbsp;Physician Organization &amp; PCPlocation values which the Parameters connect to. Below is what the report data looks like and I added the DAX fields below (this is from a CUBE or Tabular connection)&nbsp; I am thinking I should put the Year and Month in the PCpOrganization table?&nbsp;&nbsp;&nbsp;&nbsp;EVALUATEVAR FilteredTable =&nbsp;&nbsp;&nbsp; SUMMARIZECOLUMNS(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 'Providers'[PCPLocation],&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 'Providers'[PhysicianOrganization],&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 'Patients'[InsuranceType],&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 'DateDim'[Year],&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 'DateDim'[MonthNameAbbreviation],&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FILTER(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; VALUES('Patients'[Populations]),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 'Patients'[Populations] = "GM"&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ),FILTER(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; VALUES('DateDim'[Year]),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 'DateDim'[Year] = VALUE(@Year)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FILTER(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; VALUES('DateDim'[MonthNameAbbreviation]),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 'DateDim'[MonthNameAbbreviation] = @Month&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FILTER(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; VALUES('Providers'[PCPLocation]),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 'Providers'[PCPLocation] = @PCPLocation&nbsp;&nbsp;&nbsp; ),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FILTER(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; VALUES('Providers'[PhysicianOrganization]),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 'Providers'[PhysicianOrganization] = @PhysicianOrganization&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FILTER(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; VALUES('Payment'),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 'Payment'[PaymentType] = "Allowed"&nbsp;&nbsp;&nbsp; ),FILTER(VALUES('Providers'[HFPN_GMCC_Flag]), ('Providers'[HFPN_GMCC_Flag] = "Yes")),&nbsp;FILTER(VALUES('Outpatient'[OfficeVisitEncounter]), ('Outpatient'[OfficeVisitEncounter] = "Virtual Visit")),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "UniquePatients", [UniquePatients],&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "TotalCostYTD", [TotalCostYTD],&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "MemberMonthsYTD", [MemberMonthsYTD],&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "Admits1000YTD", [Admits1000YTD],"AnnualWellnessExamNumerator",[AnnualWellnessExamNumerator],"AnnualWellnessExamDenominator",[AnnualWellnessExamDenominator], "AnnualWellnessExamRate",[AnnualWellnessExamRate],&nbsp;&nbsp; "AntidepressantMedicationAcutePhaseNumerator",[AntidepressantMedicationAcutePhaseNumerator],"AntidepressantMedicationAcutePhaseDenominator", [AntidepressantMedicationAcutePhaseDenominator],"AntidepressantMedicationAcutePhaseRate", [AntidepressantMedicationAcutePhaseRate],"ERVisitsYTD", [ERVisitsYTD],&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "ERVisits1000YTD", [ERVisits1000YTD],&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "BloodPressureNumerator", [BloodPressureNumerator],&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "BloodPressureDenominator", [BloodPressureDenominator],&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "BloodPressureRate", [BloodPressureRate],"DAWNumerator",[DAWNumerator], "DAWDenominator",[DAWDenominator], "DAWFillRate",[DAWFillRate],&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "DiabetesHbA1cLessThan8Numerator", [DiabetesHbA1cLessThan8Numerator],&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "DiabetesDenominator", [DiabetesDenominator],&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "DiabetesHbA1cLessThan8Rate", [DiabetesHbA1cLessThan8Rate],&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "ReadmitsYTD", [ReadmitsYTD],&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "ReadmitsYTDRate", [ReadmitsYTD%],&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "AdmitsYTD", [AdmitsYTD],&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "AllowedCost", [AllowedCost],&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "AllowedCostYTD", [AllowedCostYTD],&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "AllowedPMPMYTD", [AllowedPMPMYTD],&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "BreastCancerScreeningNumerator", [BreastCancerScreeningNumerator],&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "BreastCancerScreeningDenominator", [BreastCancerScreeningDenominator],&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "BreastCancerScreeningRate", [BreastCancerScreeningRate],&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "ColorectalCancerScreeningDenominator", [ColorectalCancerScreeningDenominator],&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "ColorectalCancerScreeningNumerator", [ColorectalCancerScreeningNumerator],&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "ColorectalCancerScreeningRate", [ColorectalCancerScreeningRate],&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "ERVisitsRate", [ERVisitsYTDMoreThan5Visits1000],&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "ERVisitsNumerator", [ERVisitsYTDMoreThan5Visits],&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "VirtualNumerator", [OutpatientUtilYTD],&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "VirtualRate", [OutpatientUtil1000YTD],&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "DepressionScreeningNumerator", [DepressionScreeningNumerator],&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "DepressionScreeningDenominator", [DepressionScreeningDenominator],&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "DepressionScreeningRate", [DepressionScreeningRate],&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "DepressionPositiveScreenNumerator", [DepressionPositiveScreenNumerator],&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "DepressionPositiveScreenDenominator", [DepressionPositiveScreenDenominator],&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "DepressionPositiveScreenRate", [DepressionPositiveScreenRate],&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "CervicalCancerNumerator", [CervicalCancerNumerator],&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "CervicalCancerDenominator", [CervicalCancerDenominator],&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "CervicalCancerRate", [CervicalCancerRate],&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "GenericNumeratorYTD", [GenericNumeratorYTD],&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "GenericDenominatorYTD", [GenericDenominatorYTD],&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "GenericFillRateYTD", [GenericFillRateYTD],"LowBackPainImaging18to64Numerator",[LowBackPainImaging18to64Numerator],"LowBackPainImaging18to64Denominator",[LowBackPainImaging18to64Denominator],"LowBackPainImaging18to64InverseRate",[LowBackPainImaging18to64InverseRate],&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "September 2023 YTD", "September 2023 YTD",&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "Zero", 0&nbsp;&nbsp;&nbsp; )&nbsp;&nbsp;&nbsp;VAR FilteredResult =&nbsp;&nbsp;&nbsp; FILTER(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FilteredTable,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; [UniquePatients] &lt;&gt; 0&nbsp;&nbsp;&nbsp; )&nbsp;&nbsp;&nbsp;RETURN&nbsp;&nbsp;&nbsp; FilteredResult&nbsp;EVALUATEDISTINCT(&nbsp;&nbsp;&nbsp; SUMMARIZECOLUMNS(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 'Providers'[PhysicianOrganization],'Providers'[PCPLocation]&nbsp;&nbsp;&nbsp; ))&nbsp;

anonymous · Answer

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 sideIf 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 modelingPutting 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 advantagesParameter 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.

Forum Discussion

Filtering on 3 Parameter in Paginated reports

1 Reply

Related content

Looking for Better UX Ideas for Paginated Report Parameter Filters

Paginated Report - Field Parameter

Paginated report - optional parameter

Paginated Report with Parameter breaks in Service

Paginated report parameters not filtering data