Issues migrating Dax formulas from Tabular model to Power Bi desktop --- Report Builder to Power Bi

Question

For this problem I am using a TABULAR/SSAS MODEL and MUST move it FROM Report Builder TO Power Bi.&nbsp; I have copied over the DAX to structure it - but it is not calculating correctly.HOW REPORT BUILDER IS SET UP:&nbsp;I must &nbsp;&nbsp;filter multiple values in both PhysicianOrganization and then PCPLocation&nbsp; I am working on a Paginated report in REPORT BUILDER that the user would like to:Select date (Month/Year) then the PhysicianOrganization then the PCPLocation to have a pdf for that location and others only. (PhysicianOrganization must filter PCPLocation) Below the Physician Organization does not filter on the PCPLocation and it a must!Dataset1&nbsp;will be filtered by PhysicianOrganization, PCPLocation and Date (monthly reporting) which used month and year and&nbsp;PhysicianLocation Dataset which has the 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) I am thinking I should put the Year and Month in the PhysicianLocation dataset?&nbsp;I have 3 datasets that do the following:Filter the PCPLocation by PhysicianOrganization but when I run my report I do not see data:&nbsp;&nbsp;I’ve 3 datasets:&nbsp;PO – First FilterPCPLocation – 2nd filter Main Dataset which has the month/year parameterMy DAX Code is below:4 Parameters 1) PO Parameter Referencing Query 1&nbsp;EVALUATEDISTINCT (&nbsp;&nbsp;&nbsp; SELECTCOLUMNS (&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 'Providers',&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "PhysicianOrganization", 'Providers'[PhysicianOrganization]&nbsp;&nbsp;&nbsp; ))&nbsp;2) EVALUATE SUMMARIZECOLUMNS('Providers'[PCPLocation], RSCustomDaxFilter(@ProvidersPhysicianOrganization,EqualToCondition,[Providers].[PhysicianOrganization],String))&nbsp;3) Year and Month are specified Values: &nbsp;&nbsp;4)) Main dataset (in report builder)EVALUATEVAR FilteredTable =&nbsp;&nbsp;&nbsp; SUMMARIZECOLUMNS(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 'Providers'[PhysicianOrganization],&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 'Providers'[PCPLocation],&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; 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; 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; 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; ),&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; FILTER(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; VALUES('Providers'[HFPN_GMCC_Flag]),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 'Providers'[HFPN_GMCC_Flag] = "Yes"&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('Outpatient'[OfficeVisitEncounter]),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 'Outpatient'[OfficeVisitEncounter] = "Virtual Visit"&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; )&nbsp;&nbsp;&nbsp; )&nbsp;RETURN&nbsp;&nbsp;&nbsp; ADDCOLUMNS(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FilteredTable,&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],&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "AnnualWellnessExamNumerator", [AnnualWellnessExamNumerator],&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "AnnualWellnessExamDenominator", [AnnualWellnessExamDenominator],&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "AnnualWellnessExamRate", [AnnualWellnessExamRate],&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "AntidepressantMedicationAcutePhaseNumerator", [AntidepressantMedicationAcutePhaseNumerator],&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "AntidepressantMedicationAcutePhaseDenominator", [AntidepressantMedicationAcutePhaseDenominator],&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "AntidepressantMedicationAcutePhaseRate", [AntidepressantMedicationAcutePhaseRate],&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "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],&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "DAWNumerator", [DAWNumerator],&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "DAWDenominator", [DAWDenominator],&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "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; "FuInNumerator", [FuInNumerator],&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "FuInDenominator", [FuInDenominator],&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "F/U Hospitalization for Mental Illness", [F/U Hospitalization for Mental Illness],&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],&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "LowBackPainImaging18to64Numerator", [LowBackPainImaging18to64Numerator],&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "LowBackPainImaging18to64Denominator", [LowBackPainImaging18to64Denominator],&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "LowBackPainImaging18to64InverseRate", [LowBackPainImaging18to64InverseRate],&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "Zero", 0&nbsp;&nbsp;&nbsp; )&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;What I have in Power Bi is below:&nbsp;4 tables using DAX from Report Builder:&nbsp;&nbsp;&nbsp;EVALUATEVAR FilteredTable =&nbsp;&nbsp;&nbsp; SUMMARIZECOLUMNS(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 'DateDim'[Year],&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 'DateDim'[MonthName],&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 'Providers'[PhysicianOrganization],&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 'Providers'[PCPLocation],&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; // Ensure only rows with years from 2022 onward are considered&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FILTER(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 'DateDim',&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 'DateDim'[Year] &gt;= 2022&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; // Only include patients in the "GM" population with combined InsuranceType&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FILTER(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 'Patients',&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ( 'Patients'[InsuranceType] = "Attributed" || 'Patients'[InsuranceType] = "Product" ) &amp;&amp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 'Patients'[Populations] = "GM"&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; // Ensure only rows where HFPN_GMCC_Flag is "Yes"&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FILTER(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 'Providers',&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 'Providers'[HFPN_GMCC_Flag] = "Yes"&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; // Only include encounters of type "Virtual Visit"&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FILTER(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 'Outpatient',&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 'Outpatient'[OfficeVisitEncounter] = "Virtual Visit"&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; )&nbsp;&nbsp;&nbsp; )&nbsp;&nbsp;RETURN&nbsp;&nbsp;&nbsp; ADDCOLUMNS(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FilteredTable,&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],&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "AnnualWellnessExamNumerator", [AnnualWellnessExamNumerator],&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "AnnualWellnessExamDenominator", [AnnualWellnessExamDenominator],&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "AnnualWellnessExamRate", [AnnualWellnessExamRate],&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "ERVisitsYTD", [ERVisitsYTD],&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "ERVisits1000YTD", [ERVisits1000YTD],&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&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],&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "DAWNumerator", [DAWNumerator],&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "DAWDenominator", [DAWDenominator],&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "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; "FuInNumerator", [FuInNumerator],&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "FuInDenominator", [FuInDenominator],&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "F/U Hospitalization for Mental Illness", [F/U Hospitalization for Mental Illness],&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],&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "LowBackPainImaging18to64Numerator", [LowBackPainImaging18to64Numerator],&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "LowBackPainImaging18to64Denominator", [LowBackPainImaging18to64Denominator],&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "LowBackPainImaging18to64InverseRate", [LowBackPainImaging18to64InverseRate],&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "Zero", 0&nbsp;&nbsp;&nbsp; )Table 2 – PCPLocation TableEVALUATESUMMARIZECOLUMNS(&nbsp;&nbsp;&nbsp; 'Providers'[PCPLocation],&nbsp;&nbsp;&nbsp; 'DateDim'[Year],&nbsp;&nbsp;&nbsp; 'DateDim'[MonthName],&nbsp;&nbsp;&nbsp; FILTER(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ALL('Providers'),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 'Providers'[PhysicianOrganization] IN VALUES('Providers'[PhysicianOrganization])&nbsp;&nbsp;&nbsp; ),&nbsp;&nbsp;&nbsp; FILTER(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ALL('DateDim'),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 'DateDim'[Year] IN VALUES('DateDim'[Year]) &amp;&amp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 'DateDim'[MonthName] IN VALUES('DateDim'[MonthName])&nbsp;&nbsp;&nbsp; ))&nbsp;Table 3 – PhysicianOrganization (filter)EVALUATESUMMARIZECOLUMNS(&nbsp;&nbsp;&nbsp; 'Providers'[PhysicianOrganization])&nbsp;Table 4 - DatedimEVALUATESUMMARIZECOLUMNS(&nbsp;&nbsp;&nbsp; 'DateDim'[Year],&nbsp;&nbsp;&nbsp; 'DateDim'[MonthName],&nbsp;&nbsp;&nbsp; FILTER(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 'DateDim',&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 'DateDim'[Year] &gt; 2022&nbsp;&nbsp;&nbsp; ))

anonymous · Answer

Hi&nbsp;Karolina411&nbsp;,
&nbsp;
In Power BI, you could use slicer to replace the parameter in report builder.
&nbsp;
Adding slicers to the report page allows the user to interactively select the year, month, doctor's organisation etc.

Year slicer: Use&nbsp;DateDim[Year]
Month slicer: Use DateDim[MonthName]

Then try the following dax to create a calcualted table:
MyCalculatedTable =
VAR FilteredTable = 
    SUMMARIZECOLUMNS(
        'Providers'[PhysicianOrganization],
        'Providers'[PCPLocation],
        'Patients'[InsuranceType],
        'DateDim'[Year],
        'DateDim'[MonthName],
        FILTER('DateDim', 'DateDim'[Year] &gt;= 2022),
        FILTER('Patients', 'Patients'[Populations] = "GM"),
        FILTER('Providers', 'Providers'[HFPN_GMCC_Flag] = "Yes"),
        FILTER('Outpatient', 'Outpatient'[OfficeVisitEncounter] = "Virtual Visit")
    )
RETURN
    ADDCOLUMNS(
        FilteredTable,
        "UniquePatients", [UniquePatients],
        "TotalCostYTD", [TotalCostYTD],
        "MemberMonthsYTD", [MemberMonthsYTD],
        "Admits1000YTD", [Admits1000YTD],
        "AnnualWellnessExamNumerator", [AnnualWellnessExamNumerator]
        -- other columns
    )

To better test this for you, please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
&nbsp;
Do not include sensitive information or anything not related to the issue or question.
Additionly, please show the expected outcome based on the sample data you provided.
&nbsp;
Best regards,
Joyce
If this post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly.

&nbsp;

karolina411 · Answer

https://drive.google.com/drive/folders/1f2dNUj2ZOOsdVaW3B2TXNAFVuO_ALEGF?usp=sharing

Above are 3 files that may help. Is there a guide on how to transfer from report builder (.rdl files) to .pbix files? This data is being pre-processed in a VS model.

Forum Discussion

Issues migrating Dax formulas from Tabular model to Power Bi desktop --- Report Builder to Power Bi

2 Replies

Related content

If formula

formula

DAX Formula Help

Migration to Power BI

Migrating ADF to Fabric