Forum Discussion
Seriously need help with Report Builder Query functions - I am using a Saas/Tabular Model
I am attaching the .rdl file in hopes of desperate support with a field in my data set Step 1 Here is my dataset (from a Tabular SAAS model) Step 1b Step 2 Step...
Thank you. The dataset worked perfectly until I added the PhysicianOrganization PARAMETER. it did not work when I selected 'Add from dataset' so I had coded the 7 options like the photo below. I then referenced it in my dataset like this: FILTER(VALUES('Providers'[PhysicianOrganization]), ('Providers'[PhysicianOrganization] = VALUE(@PhysicianOrganization))
I then added it to the dataset
Hi Karolina411 ,
What is the data type of column 'Providers'[PhysicianOrganization]? Text type or Integer? Please update the filter context as below and check if it can work:
FILTER(VALUES('Providers'[PhysicianOrganization]), 'Providers'[PhysicianOrganization] = @PhysicianOrganization)Best Regards
I did add that into Dax and get the same error:
The query contains the 'PhysicianOrganization' parameter, which is not declared. (Microsoft Analysis Services)