Data blending has some limitations regarding non-additive aggregates such as COUNTD, MEDIAN, and. Viz cannot be filtered with secondary data source filter before loading the visualization so using "[DS_Name]. Can't see what you are actually doing but Blending data has its limits. Relationships: Join: Combines columns: Yes: Cross database joins will not work with all data sources: Joins: Blend: Combines columns: No: Fields from the secondary data source cannot be brought in to the view unless there is a match on. AUMTable (Secondary) 3. Maxdate) There is one more way, make the datasource which is using the fixed calculation to primary data source. Sometimes , it's automatically working but sometimes it says 'Unsupported Aggregation' . Size() is a great choice for unique counts across data sources if you can create a view where every unique row is displayed. Upvote Upvoted Remove Upvote Reply. To fix this, we had to add the fields being used in the blending relationship onto the view: If attempting to use COUNTD in a secondary data source when blending, see the following additional workarounds: If Tableau Prep cannot be used, see: Getting around Count Distinct in a secondary data source (third party website) Creating a primary group: Bring a Field into the Primary Data Source in Tableau Help Sorted by: 2. To fix this, we had to add the fields being used in the blending relationship onto the view: Aside from a few of these, we didn’t need to combine the data in very complicated ways. You can read details here: Logical Tables in Secondary data source. 5 3 . png - Ben-Sullins's library "Cannot blend the secondary data source because one or more fields use an unsupported. Data blending is a method for combining data from multiple sources. Upvote. I have 2 separate data sources that have similar fields. Primary and Secondary sources in data blending. Think of this layer as the Relationships canvas in the Data Source page. "Cannot blend the secondary data source because one or more fields use the / function, which cannot be computed locally. In data blending, there is a primary data source and a secondary data source. I read that this is not possible. Both fields are linked in worksheet. Hi there, I got a question about how can I count distinct customer ID? I have 10k customer IDs, some of them appear more than once. LOD calculation and blended data sources. I'm trying to blend two data sources on a single field, say 'Program Description'. You can create a federated database using linked tables/worksheets. Secondary data source: spatial file containing the geometry. Error: Cannot Blend the secondary data source because one or more fields use an unsupported aggregation. xls files). How to calculate Delta value. In the data window, switch to [name1] data source, and click at least one link icon to blend these data sources. For more information, see Troubleshoot Data Blending; Blended data sources cannot be published as a unit. For example, when I try and pull in Cost per Order (cost coming from one source, and Orders coming from another) I get the "Cannot blend the secondary data source because one or more fields use and unsupported aggregation. For example, sheet A uses data source 1 as the primary data source; sheet B uses data source 1 as the secondary data source. Using existing secondary data sources can save researchers time and resources by providing access to pre-existing data that has already been collected and organized. The version I am working with 10. Left. When I create an additional calculated field in the primary data source with: COUNTD(Person ID) + COUNTD(Person ID), I receive the cannot blend the secondary data source because. I can add to filters from the data extracts. When blending in Tableau, there is always a primary source and a secondary data source. It would be nice if when you blend two data sources, you could have the option to show "Only Relevant Values" on filters used from the secondary data source. " Expand Post. Select Analysis > Create Calculated Field. Select Custom in the relationships list, and then get Attach. This can help researchers identify. CSS ErrorI am trying to put my LOD calculation (below) on the rows shelf but encountering "cannot blend the secondary data source because one or more fields use an unsupported aggregation" {include [DATE. All the data is in the secondary/blended data source. A datetime field may be converted to a date field using a calculation to remove the time portion. One approach that succeeds in adding another measure is to add the measure in question to your. I have my primary data source with dimensions customer and order no and a secondary data source with customer, postcode and an 'is vat exempt' boolean field. Instead, publish each data source separately (to the same server) and then blend the published data sources. I'm trying to create a frequency distribution as a percent of total for individual products in a single category on one chart, then dual axis a second chart with the frequency distribution of the category for comparison purposes. 3. To blend on summary data, you can do the following: Create a. Chicken + Choice of DrinkBurger + Choice of DrinkSpaghetti + Choice of Drink . 3) Select the now grey link next to the original field in. In the Data pane, switch to the [name of secondary data source] data source, and click at least one link icon to blend these data sources. Before I check Date filters, I got this results. And I can't explain why it does that. If there is another aggregation type such as AGG_AVG being used, change it to one of the supported aggregation listed above in the cube database itself before using in Tableau Desktop. You must double-click a logical table in the Data Source page canvas to go to the physical layer of the canvas. 3 and I have created aggregates AGG for fields from data extract and excel file. 1. Drag the State (group) dimension over the Region dimension on the Rows shelf to replace it. There's a set of views/calcs that show a metric, (metric C) counting distinct number of accounts contacted per person per week (e. I have two datasets; one is a shape file that contains regions and locations. I'm blending the 2 data sources by Service_Id. I am blending 2 data sets by employee id and when i am trying to group a field from the primary database, it is showing me below error: Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Cannot blend aggregated data from the secondary data source with the data on this sheet because there are no linking fields used in the view. Answer. I ended up purchasing an Alteryx license for our company (we now have a lot. And I use Join data source, after divide measures / row duplicate. Loading. Secondary data source has Order Date represented as separate Year and Month fields. Loading. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. A Level of Detail (LOD) expression is being taken from the secondary data source. FIXED requires that you have row-level access to the rows in the secondary source. For example, when I try and pull in Cost per Order (cost coming from one source, and Orders coming from another) I get the "Cannot blend the secondary data source because one or more fields use and unsupported aggregation. Someone in the Community told me the following:A common use case for my analysis is blend a secondary data source then do a table calculation with various independent measures (thus I cannot apply filters). Primary Data Source: Contains a list of all employees and their role. CustomOverall (Primary) 2. The data in the primary data source is the main data on which Tableau defines graphs and charts. 3 and I have created aggregates AGG for fields from data extract and excel file. ” We use three kinds of cookies on our websites: required,. Then try using the LOD expression from a secondary data source. For more information, see Deciding Between Joining Tables and Blending Data. After blending, CountD works fine on primary datasource, but when I try to use CountD on secondary datasource tableau gives error: "Cannot blend secondary data source as one or more fields use an unsupported aggregation". The reason of the errors being unsupported calculation in blend. This is the final step and will result in filtering between the blended data sources at your desired level of granularity. It takes advantage of the data collected from previous research and uses it to carry out new research. data source. When I do the join between the SSAS Tabular Model (primary data. As 'Group' is from a secondary data source, I cannot simply use the sort buttons. 3. One small workaround which you can do is: 1) Create a calculation as {Max([Date])} 2) Create a parameter as follows: 3) Create a calculation as . Resolution. To overcome this, I've added a filter straight into the data source and not in the view. Jim. Try one of the following options, as appropriate for your workbook: It may be possible to cross database join instead of blending. Option 2: Join tables that are in the same data source, instead of blending them. Blended data sources. Secondary Data Source: Contains data relating to the usage of a website (hits). A COUNTD of Order ID should be all I need to show this data but it always results in a "Cannot blend the secondary data source because one or more of the fields use an unsupported aggregation". Beyond that personally I tend to do the work necessary to avoid using data blending in production data sources & views. The condition is offer status = hired, but offer status can contain my different response types. I have three different data source . For more information, see Use Relationships for Multi-table Data Analysis. The data source with the KMs is the primary source. Upvote Upvoted Remove Upvote Reply. Note: If the geographic role does not exist in the primary data source, then it will be necessary to create the view with the data source that contains the geographic role as the primary data source. Tableau will throw an error: “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. I have 2 data sources, A and B, they are linked by data blending with A. 2) Use this duplicate field in the view instead of the original. Another table is a a table that contains key fields such as date, region, location and hardware id (dimension). From my primary data source I have a dimension in columns say 'Customer Segment'. I've read through the various posts on here, plus the general troubleshooting posts on the Tableau page on blending data, but can't find a solution. If you are blending a cube data source, it must be the primary data source. Data blending is particularly useful when the blend relationship—the linking fields—need to vary on a sheet-by-sheet. Change the default sort order of the field using the various options, and then click OK. Secondary data sources cannot have logical tables (except when they satisfy specific conditions). the blend relationship is defined on driver Code, and working fine when adding both basicSalary (from main data source) and fuel (from secondary) to the sheet. Modify the calculation to not use table functions;. Data blend is like a Left outer join. I would like to visualize number of distinct hardware. I have just realised why the blending was not working. Currently, data sources that contain logical tables cannot be used as secondary data sources for data blending. The blend applies to that worksheet only. BR, NBBlended data sources cannot be published as a unit. 4, I tried to blend products (secondary) to storefront (primary) based on Sku. Tableau Desktop; Blended data; Soluzione Use the following workaround: Create a new worksheet. Instead, publish each data source separately (to the same server) and then blend the published data sources. Primary Source: Payment details (to get customer ID and revenue) Secondary Source: Customer details (to get customer country)from this data source i get the sum of basic salary. tds and . You want to apply a filter to related data sources - which is an option if multiple data sources have a field with the same name and data type, or if you define explicit relationships between data sources from the Data menu. Does anyone know if there is a way around this or can you only create a blending whit datasources that were created the same way? I appreciate your help. And I want to add one of the field from secondary dataset to be in the filter. Currently, data sources that contain logical tables cannot be used as secondary data sources for data blending. Are use of grouped fields not allowed in data blending? I have two data sources: Opportunities and Products. I have two data sources and doing a data blend. The concept of data blending is, for every match in the primary table there should be exactly one row item in your secondary table, in the view of this concept any aggregation on the secondary table will always be distinct by default. I get error: “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. In the secondary data I have a LOD field called Total_Category_Response defined as { FIXED [Category]: SUM([Respose_ValI am working on a dashboard where I am using the data blending feature to visualize the data from different data sources in to a single view. Common Issue #1: Cannot blend the secondary data source because one or more fields use an unsupported aggregation The aggregation methods of COUNTD, MEDIAN, and other non-additive aggregate functions can cause fields to become invalid. What steps do I need to do to do this?It shows the next message: "Cannot blend the secondary data source because one or more fields use an unsupported aggregation". I am trying to create a waffle chart. Status, Stage, etc). twbx. The chart should display: countd. Make sure that you are blending on dimensions present in the view or on all of the. Data blending provides a way to combine data from more than one data source on a single worksheet. In your workbook sheet2 does not contain 5/22 date. Filter each of the data sources independently on the more granular dimensions. I am just trying to filter every Data source, by choosing a field that every Data source has. From my primary data source I have a measure in rows, say 'Measure, which is 'distinct count of Pol Number' or 'sum of Premium' depending on a boolean parameter's values (TRUE or. , it's difficult to determine; however, what you could do is click on each data source and if you see a chain link that is solid and not broken where fields might be related/blended in the tables below, then click the icon to unlink it. Loading. blending takes place in step 6 of the Order of Operation after all the context and dimension filters have been applied - you will not be able to filter across the data sets after that point - you would need to have joined data or use a relationship The issue comes when I try and add a metric that is an aggregate of the two different sources. This happens only when the data sources are impala. Fee". Expand Post. I would like to ask for your help, I do have two data sources: BI Cube (primary source) & Excel file (secondary) BI Cube Data 1 pc. Next, create a table calc using the [Start KM] to calculate the total KMs: from Primary data source from Secondary data source. Are use of grouped fields not allowed in data blending? I have two data sources: Opportunities and Products. Currently, I have to rebuild the worksheet and bring in the secondary source first. " The only fields used in the view are the date fields, to which I did a . We are blending two data sources. Make the data source that contains the field that you want to use in the URL action the primary data source in. newBranchProjection (Secondary) When I try to add COUNTD([DistrictId]) from my primary to text table. Some of my table calculation are the follow: RED FIELD Tableau Name of First Math Course= IF [Tableau Period of First Math Course]== [Academic Period] AND ( [Subject Desc]=='Mathematics' OR [Subject. I am trying to determine the Average Revenue per User by country for which my calculation is total revenue/unique subscribers. Please check the attached workbook for details. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Non-additive engine are entirety functions that errichten outcomes that cannot be aggregated along a dimension. If attempting to use COUNTD in a secondary data source when blending, see the following additional workarounds: If Tableau Prep cannot be used, see: Getting. I am creating a couple of formulas to display the total booking from the second data source to the first data source. Instead, the. 1. " inner cross database join on BU Code with a data source filter set up on UPPER([ID])=UPPER(USERNAME()) on the DS2 source. The. While on a view, right click a data source, click replace data source. Primary and Secondary sources in data blending. order_date. I am able to achieve the desired results but I am getting a warning ' Fields cannot be used from the [name of secondary data source] data source, because there is no blend relationship to the primary data source. Data sources can contain logical tables not be used as secondary data sources for data blending. COUNTD - Blended data. Try one of the following options, as appropriate for your workbook: It may be possible to cross database join instead of blending. LOD Expressions will not be shown in the Data Source; When referencing a dimensionality declaration parameter, always use the parameter name and not the parameter value; With data blending, the primary data source's linking field must be in the view before you can use a LOD expression from the secondary data source. Advantages: Very easy to write and implement. ”. From Primary Data Source drag the measure names and measure values . But the source calc is a countD. Identify your data sources for common data types: both data sources must have a string or date field for linking data sources. Good morning . We don't get row-level data from secondary sources on a blend. an aggregated left join where the aggregation of the secondary data cannot be used to increase the level of detail of the primary data. Last week I’d promised to explain why the solution for identifying whether All items in a Tableau Quick Filter were selected wouldn’t work under certain circumstances in Tableau version 8, here it. To alias field values. the branch field I'm using from the primary data source. If you create a quick filter on a field from data source 1 and apply this. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. However, I still get that message saying cannot blend the secondary data source because one or more fields use an unsupported aggregation". Hi everyone, my first attempt to blend 2 data sets was not successful (Sheet called 1st attempt - attached), because its appears the following message "Cannot blend the secondary data source because one or more fields use an unsupported aggregation". A key difference with blending is that data is aggregated before being "joined" - you'll notice this when you include a column from the secondary source in a calculation in the primary source. CSS ErrorCannot blend the secondary data source because one or more fields use an unsupported aggregationFollow this link for more information:the secondary data source always has to be aggregated, there's no way to do a row level check to filter out any dimension members that match between the two data sources. I think I need to define the relationship between the data sources. ” Causes and Workarounds for a Blending Limitation Errors. I am confused, as I am not even trying to blend Data from both Data Sources. Because there are no linking fields in this view. ” Causes and Workarounds for a Blending Limitation Errors 1. Please post you twbx workbook so we can see if there a way . What does this mean? I want to create a city filter and apply it both to the SAS data source as well as the pivoted CSV file. " And after that I can't make my workbook work at all. The primary data source is just to filter for the invoices I want to look at. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Aside from consulting the primary origin or source, data can also be collected through a third party, a process common with secondary data. " message. Error: "data sources that contain logical tables cannot be used as secondary data sources for blending" I have two fact based data marts that I want to blend on a combination of dimensions (product, month, currency). Then you can simply show one filter control on your dashboard and set it to apply to all related data sources. General Information. In the Add/Edit User Mapping dialog crate, do the following: Select a select by the primary your data. Blending runs a query on each data source and joins the aggregated results of those queries. It also means you cannot create a workbook using the. Hi Kurt! No, not really. Data from a secondary source is displayed along with the primary source data. We use three kinds of cookies on our websites: required, functional, and advertising. Cube data sources do not support pass-through connections. For example, sheet A uses data source 1 as the primary data source; sheet B uses data source 1 as the secondary data source. Some examples include: cookies used to. The blend applies to that worksheet only. However, when I follow your advice, each group splits into 6 rows (one for each month - January through June). "Cannot blend aggregated data from the secondary data source with the data on this sheet because there are no linking fields use din the view" I'm using 2 separate data sources connected to Oracle and published to the Tableau server. the branch field I'm using from the primary data source. You can choose whether functional and advertising cookies apply. 1. ×Sorry to interrupt. the message says that a Logical table can not be used as a secondary source - You are trying to blend data (or at least tableau thinks you are) try reverting the data connection to a Physical model to JOIN the files together on the company name - JimClick OK to close the Edit Group dialog box. Process for Creating the Dynamic “Parameter”. If this aggregation is ATTR() then the grand totals may be blank. To the Data pane, umschaltung in this [name of secondary data source] data source, real click at lowest one link icon to blend that data sources. I have 2 duplicate data sources that I am blending together (they are duplicate because I want to filter the same data source 2 different ways but show it in. i. CSS Errorthe message says that a Logical table can not be used as a secondary source - You are trying to blend data (or at least tableau thinks you are) try reverting the data connection to a Physical model to JOIN the files together on the company name - JimThe secondary data source hasn't been changed and the groups work as filters. If if this is the case, you could try creating a calculation for DAY([Endtimestamp]) in both the primary and secondary data sources, and adding it to the blend. 1) When we add fields from secondary data sources to a view Tableau “joins” the data as part of the blend on one or more linking dimensions. A datetime field may be converted to a date field using a calculation to remove the time portion. 1. I have the same issue, but Primary Data Source is a Tableau Server Data Source (I do not have direct access to the database), and Secondary Data Source is an excel flat file. But I cant add filter Month from the Budget Excel file. In a blend, secondary data sources are aggregated and the StoreID dimension would be aggregated to "*". If you want to filter data across secondary data sources, consider the following alternatives: Join tables that are in the same data source, instead of blending them. All three options are demonstrated in the attached workbook using the sample data set Superstore. if that is the case I could get same results by joining 2 data sources just by linking Area and Qtr not all 4 and without using LOD for secondary data source i. e. Both Primary and Secondary data sources have duplicate rows due to multiple joins in data prep. Cannot blend the secondary data source because one or more fields use an unsupported aggregation" when Data Blending. Pick the secondary data source in of Secondary data source pane. With the recent release of Tableau Desktop 2020. Make sure that you are blending on dimensions present in the view or on. Give the action a sensible name and configure the action. - Data to Map from - Data to Map to . The two values you mentioned, 5315 - Radio and 5345 - Public Relations, do not appear in your primary data source for 2012, but do appear in the secondary data source, so they cannot be included in the data. Cannot Blend Secondary Data Source - Unsupported Aggregation. Assuming that's what's going on, there's the question of how to work around this. However, some days will have entries for "Cost" but not for "Proj. They cannot be used as secondary data sources. you will get 5/22 date. The two data sources are identical. If multiple logical tables are related in a Tableau data source that source cannot be used as the secondary data source in a Tableau data blend, it can only be used as the primary Therefore one workaround is the Create Primary Group function that you described which "copies" the field from B into A as a group. Data & Connectivity. Non-additive aggregates are aggregate functions that produce results that cannot be aggregated along a dimension. Input cannot become used from the [name are secondary data source] data source, because there is no blend relationship to the primary data source. We cannot use ATTR if trying to create an LOD type calculation if blending data sources. " Is there a way to circumvent this issue? Or perhaps a different method entirely. Thanks for your help everyone! I've found what was happening: I had some filters on the secondary data source. During Data Blending in Tableau, if the secondary data source has any LOD (Level of Detail) Expressions, they are taken down after the data blending process is finished. 2) Use data source filters instead of the Filters Shelf. Whichever data source you "use first" in a view (by dragging in a field) becomes Primary. The primary data source will be identified automatically from any metrics you put on the worksheet first. Some examples include: session cookies needed to transmit the website, authentication cookies, and security cookies. 4. "Cannot blend the secondary data source because one or more fields use an unsupported aggregation" I have tried the following calculations but have not been able to figure this out. like below . Chicken + Choice of Drink1 pc. . ”. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Did some research on this and found plenty of "workarounds" with no success (like replacing COUNTD() with a LoD using AVG(# of Records))Workaround: Option 1: Instead of using Data Blend, please use Relationship to relate the data sources, and the "Only relevant values" option is available to show only existing values. cannot blend secondary data source because one or more fields use an unsupported aggregation beacuse of LOD. This feature would be really useful to ensure we can. This is indicated by the following icon: The view you are trying to build will function if you use the date from the primary data source (Shipped): Let us know if this is clear, or if more explanation is required! Cheers, TimothyCube data sources are used as primary data sources to blend data in Tableau and cannot be used as secondary data sources. "Cannot blend data from the secondary data source with the data on this sheet because there are no linking fields used in the view" Expand Post. Primary Data source - Actuals ( day grain) Secondary data source - Goals (quarter grain) Calculated Measures: Primary Data source :- CustCount = CountD( Cust_ID ) Secondary Data source : %of Goal = CustCount/SUM([Goal])The physical layer of the Data Source page canvas is basically the "classic view" of the Data Source page in previous versions of Tableau. If you want to filter data across secondary data sources, consider. Hello Jim, Thank You for your reply. The syntax for calling secondary data source field is not. Now the nightmare starts: when I try to add the data source B and make all the relationships, it gives me the lovely error: "Cannot blend the secondary data source because one or more fields use the ZN function, which cannot be computed locally. The date values must be in the same format. This link might help you: Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Yes - you can't bring COUNTD in data blending. Hi . Another way to approach this is to do a join of the data outside Tableau via a federated data source. You can choose whether functional and advertising cookies apply. What I'm trying to do is, create a new column in the 'data to map to' table, saying I only want to see 'PY Sales' numbers where the 'Period' column is equal to the MAXIMUM of 'Sales Cycle' column from 'Data to Map from' table, which is from. Drag the 2016 Population measure to the Columns. Ritesh Bisht (Member) 6 years ago. Filtering data across a worksheet's secondary data source is not currently supported in Tableau Desktop. Summary:. The secondary data source just pulls in some names to associate with ID numbers in the primary and some filters for the staff data. Data blending works like a ___ join. I am trying to blend the same data against the other because I wanted to show Same Period last Year. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. When I put category on either the row or column shelf I am getting the erro r "Cannot blend the secondary data source because one or more field use an unsupported aggregation". [tier] == 2 'Top Vendors' else 'Mid Vendors'. I have two data sets that are linked across Date and Product Category fields. I've created the first chart with no problem, but I. I use the Opp ID to relate them. Filtering data across a worksheet's secondary data source is not currently supported in Tableau Desktop. Relationships cannot be formed between tables from data sources published to Tableau Server or Tableau Online. If the user select May 2018. Hi. Nitish Pamarty (Member) 7 years ago. If you want to filter data across secondary data sources, consider the following alternatives: Join tables that are in the same data source, instead of blending them. Click on the ‘Add Action’ button and choose ‘Change Set Values’. So the only way, it was possible was to connect one of the data sources with a calendar table joined with previous year and then blend it against the same data to get the Current Year and Same Period Last Year values in a single view. [Field_Name]":"Value_to_filter" in the Options will not work. Filter not recognizing blend relationship. Click oLoading. I'm trying to show a distinct count of claims by branch. See. [OIL DATE]) THEN MIN ( [KMs]) END. This would be a great time saver, with all of the calculations and linking changing as well. amount into the view, it gives me the correct sum. Loading. For more information, see Troubleshoot Data Blending; Blended data sources cannot be published as a unit. Click oField cannot breathe used from the [name by secondary data source] data original, because there is no mixed relationship to the primary data original. I am using tableau 2020. I have quick filters from the primary data source and I am trying to represent distinct. When blending in Tableau, there is always a primary source and a secondary data source. When trying to use COUNTD() it gives this error: cannot blend secondary data source because one or more fields use an unsupported aggregation when hovering over the Measures because it is now red. If one of those measures is brought into a view with a linking dimension not in the view, or a linking dimension is turned on that is not in the view, the pill will turn red, the view will turn grey, and hovering over the pill reveals a "Cannot blend the secondary data source because one or more fields use an unsupported aggregation. 0 and 7. I. Each has a joining field with the same name. However, when the linking dimension is not in the view, non-additive aLoading. CSS ErrorI want to blend data from two different sources but on blending the data the filters from primary data source do not work if the case is different in the secondary data source. Because the question is related to how the data sources are being related, it would help to see the real data structure. I am trying to determine the Average Revenue per User by country for which my calculation is total revenue/unique subscribers. 2 came the introduction of a brand-new data model. I am trying to use the below formula instead of countd function because my data comes from Impala. I have a primary data source coming from a published data extract blending with a secondary data source coming from an Oracle Database. All data from a secondary source comes back as an aggregate -- even if there is only one value from the secondary source. i will try to build some moke up data in excel and reproduce the same but before that could you please explain me in detail what calculation i need to perform in secondary source. Please check the attached workbook for details. 3) COUNTD with Secondary DS (Blending) Thanks,. Complex as the problem may be, the solution is comfortingly simple. Use a parameter with a calculated field to filter the secondary data source at the row level. Some of the function doesn't work properly when we use blending like COUNTD(), LOD{} expression.