Hi . This happens only when the data sources are impala. Currently, data sources that contain logical tables cannot be used as secondary data sources for data blending. The reason of the errors being unsupported calculation in blend. (It is a field that contains account names (company) in the sample data. newBranchProjection (Secondary) When I try to add COUNTD([DistrictId]) from my primary to text table. The secondary data source consists of 1 Fact table (Agg_ActualVsExpected) and 4 Dim tables, one of the Dim tables is Dim_Service, whose primary key is Service_Id, which appears also in the Fact table. I am blending dates in the secondary data source to dates from the primary source and looking to get a distinct count of the customer code from the secondary data source. 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. 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. In the Add/Edit Field Mapping dialog box, select the date fields from the primary and secondary data sources, and then click OK twice. The data is blended on customer. Currently, I have to rebuild the worksheet and bring in the secondary source first. The data in the primary data source is the main data on which Tableau defines graphs and charts. There are a few possibilities: 1) Flip the blend so the primary is secondary and vice versa. additionally, data coming from the secondary source are always aggregated at the level of the link when brought to the primary source - the individual records are no longer available and you are not able to filter across the various data sources at that point - that is the long way of saying you will have to join or use a. (I created calculated fields "Fiscal Year" and "Fiscal Month" on my secondary Superstore example to simulate this. Answer. Now we have to use W2 as Filter - to filter out the data. Also, data blending is useful for combining data from published. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. I noticed there was an issue using Data Blend from 3 different source. Then try using the LOD expression from a secondary data source. I have three different data source . Option 2: Create a calculation using WINDOW_SUM() Drag the linking field(s) from the secondary data source to. I have two data sources and I have blended them together. Click oLoading. See Join Your Data for more information. "Cannot blend the secondary data source because one or more fields use the == function, which cannot be computed locally. Data coming from a secondary source is ALWAYS aggregated at the level of the link - even if there is 'no need to add anything' that's just the way blending works - it happens after the data table dimensions are set and you are loading values into the data table for the individual worksheet additionally, data coming from the secondary source are always aggregated at the level of the link when brought to the primary source - the individual records are no longer available and you are not able to filter across the various data sources at that point - that is the long way of saying you will have to join or use a relationship - not. " Is there a way to circumvent this issue? Or perhaps a different method entirely. In the secondary data source, select Data > Create Calculated Field. 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. Chicken + Choice of DrinkBurger + Choice of DrinkSpaghetti + Choice of Drink . 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). You can read details here: Logical Tables in Secondary data source. However, when I follow your advice, each group splits into 6 rows (one for each month - January through June). Upvote. The solution. . "Data Sources that contain logical tables cannot be used as secondary data sources for blending". All customer IDs are under a dimension called "Global ID". I'm trying to show a distinct count of claims by branch. Try one of the following options, as appropriate for your workbook: It may be possible to cross database join instead of blending. Status, Stage, etc). Primary Data Source: Contains a list of all employees and their role. good morning you have blended your data sources - data from the secondary source always comes to the primary and an aggregate so Budg_date needs to be aggregate with min max or attr but that will probably not give you the result you expect the data from the secondary source will come over as an * if there is more than one date filtered from that. Limitations of Data Blending in Tableau. Data blending is a method for combining data from multiple sources. I have some extra supplemental data in a CSV file that I would like to join to one of the common fields between the two so I can pull some of the SSAS measures by the supplemental data's dimensions that I've blended. In the secondary data source, select Data > Create Calculated Field. I'm blending the 2 data sources by Service_Id. But I cant add filter Month from the Budget Excel file. 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. {FIXED [Machine Nr] : COUNT ( [Machine Nr] )} / {FIXED [Machine Nr] : COUNT ( [Machine Nr] )} This works fine when there is no secondary data source but when I blend with a secondary data source it grays. Option 1: Include all linking fields in the view, and aggregate secondary fields Data blending will work when the secondary data source uses logical tables, as long as the following conditions are met: All active linking fields from the primary data source must be included in the view on a shelf other than the Filters shelf Link Primary Source and all other secondary source on this Field Created from step 3- 4 using Edit Data blend Relationships 6. Not able to share for time being. These latter two situations trigger a different style of data blending (DB2) inside Tableau to ensure an accurate blend and that makes computation of non-additive aggregates much more difficult. While on a view, right click a data source, click replace data source. A Level of Detail (LOD) expression is being taken from the secondary data source. I get error: “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. The point is to do row-level work in the secondary source, so that when the blend pulls data it doesn't have to do the row-level work. Verify if one of the measures coming from the cube data source has a default aggregation different than SUM, MIN, MAX, COUNT. Tableau automatically adds an aggregation (SUM) around the column from the secondary source. I am trying to determine the Average Revenue per User by country for which my calculation is total revenue/unique subscribers. When you blend, you can only have aggregate access to the rows in the secondary source. Expand Post. Data blending; Table Calculations; Resolution Use one of the following workarounds: If possible, join instead of blend your data. ) So the issue is really the introduction of the group on the sheet. But I cant add filter Month from the Budget Excel file. Data blending brings in additional information from a secondary data source and displays it with data from the primary data source directly in the view. We use three kinds of cookies on our websites: required, functional, and advertising. Observations : 1. To solve your issue you should ->go to Connections 2 , keep only facADP and remove all other relationships ->go to its physical layer (double click facADP)Two Data Sources A and B, one work sheet:W1 has used both this A and B to represent View. So, to do Data Blending, the steps that I would suggest would be: - Connect to the data sources that you need to use. Change the default sort order of the field using the various options, and then click OK. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Loading. you are blending the 2 excel data sources - blending takes place after the structure for data table for the worksheet has been established - and that is done as you bring dimensions to the rows and columns and apply filters to those dimensions - you will not be able to filter across data sources except at the link after that point💡 Ability to switch primary and secondary data sources. 2) Use this duplicate field in the view instead of the original. 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 only one of the tables requires row level information, consider making that the primary data source in the blend (I. You can create a federated database using linked tables/worksheets. 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. Please attach. Before I check Date filters, I got this results. Loading. We are blending two data sources. Reference line -----> in this approach able to show sub-category items measures like sales and quantity totals as reference lines shown in below figure . I am creating a couple of formulas to display the total booking from the second data source to the first data source. ” We use three kinds of cookies on our websites: required,. Cube (multidimensional) data sources have certain characteristics that make them unique in Tableau. 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". If we are working with one data source that is not relatable or joinable (such as Google Analytics) you are not able to blend a secondary data source with logical tables to it. With the recent release of Tableau Desktop 2020. It takes advantage of the data collected from previous research and uses it to carry out new research. I can't do a join because they are two different file formats. "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. But seems we cannot blend 2 secondary data source with same field. You are trying to bring fields from a second data source into a calculation that is being created in the primary (first) data source and aggregations are not consistent - data from the second source comes over as an aggregate - look into what the aggregation is on and how does that relate to what you have in the primary data baseI'm trying to blend two data sources on a single field, say 'Program Description'. Any help would be appreciated!Also a data blend is only a LEFT join. 3) COUNTD with Secondary DS (Blending) Thanks,. I. ×Sorry to interrupt. " And after that I can't make my workbook work at all. "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. [Field_Name]":"Value_to_filter" in the Options will not work. Data source filters. The reason your blend breaks is that you're blending with Location as a linking field, so when you remove that from your view, Tableau can't blend any longer. Use the geographic role in the primary data source on detail instead of the dimension from the secondary data source. This didn't work alas, "cannot blend secondary data source because one or more fields use an unsupported aggregation" I am using a filter from a different datasource to filter by region . Data blending is used when the linking fields need to vary on a sheet-by-sheet basis for different visualizations. Instead of using relationships, double-click into your table to get to the. Now try to recreate the sheet and link the 2nd and 3rd data. I am using tableau 2020. It says, "fields cannot be used from [data name] data source, because there is no relationship to the primary. targets. 3 and I have created aggregates AGG for fields from data extract and excel file. Hello Jim, Thank You for your reply. Blending runs a query on each data source and joins the aggregated results of those queries. - Dataset 1, records the amount spent on ads as "Cost". If you make sheet 1 as the primary data source and do the data blending with sheet 2. For secondary data source you get same result by managing relationships in your case just Area and Qtr. Hello Tableau world!! Am running into the strangest problem when data blending with V8. A datetime field in the primary data source, for example, will not blend with a date field in the secondary data source. No. Loading. I can add to filters from the data extracts. "cannot blend the secondary data source because one or more fields use an unsupported aggregation" Attached is the workbook that could provide more clarity on my question. "cannot blend the secondary data source because one or more fields use an unsupported aggregation" Attached is the workbook that could provide more clarity on my question. This is the response I received from Tableau Support:Cause. Notice that Calc1 gives you an asterisk if there are multiple values returned from the secondary source. For more information, see Troubleshoot Data Blending; Blended data sources cannot be published as a unit. Try one of the following options, as appropriate for your workbook: It may be possible to cross database join instead of blending. But I cannot for the life of me comprehend why the data blending would behave differently based solely on the chart type that was selected. Data blending: Cube data sources can only be used as the primary data source for blending data in Tableau. Secondary data source: (excel) master zip file with ~40k rows (all US zips) - each zip is tied to a territory I am looking to add the territories from the master zip to territory file as a filter. Hi, I'll expand a bit on what @Chris wrote: There are some fundamental limits to what can be done with data blending and while there are workarounds that can get us the desired results in some circumstances those workarounds will not work in all circumstances (because Tableau never built out data blending to handle every. In the attached file, table shows the sum of sales and first order date correctly from both the. 4. 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. 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. So, basically, I am having issues with 2 calculations - the FIXED LOD and Remaining Value. 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. These latter two situations trigger a different style of data blending (DB2) inside Tableau to ensure an accurate blend and that makes computation of non-additive aggregates much more. Why are values from the secondary data source not appearing in a blended data source view? They did not exist in the primary data source. See. I establish the blend relationships explicitly by going to Data -->Edit Blend Relationships, and selecting the fields that should be related. Regards. Cube data sources do not support pass-through connections. Calculates the number of distinct values of a field within a partition. Another sheet:W2 is created with Data source A - taking Role in Row shelf. The success of BI projects depends on an organization's choice of BI solutions and the vendor’s ability to deliver relatively rapid and successful implementations, along with supportive. A datetime field may be converted to a date field using a calculation to remove the time. Hi Justin, Thanks for your quick reply. When you blend, you can only have aggregate access to the rows in the secondary. As we know the link cant be established unless we use this common dimension (Region Filter) in the view, we can mimic the view by adding the Region Filter Dimension to rows/Columns shelf and uncheck the show header. Error: Cannot blend the secondary data source because one or more fields use an unsupported aggregation I have a primary data source coming from a published data extract blending with a secondary data source coming from an Oracle Database. The version I am working with 10. order_date. and tried to plot chart, the chart complains that "Data sources that contain logical tables cannot be used as secondary data sources for data binding". You can choose whether functional and advertising cookies apply. I'm able to successfully connect to both data sources and set up the relationship, with the Teradata extract being primary and the Excel sheet being secondary. Good morning @Fred Yu (Customer) . Filtering data across a worksheet's secondary data source is not currently supported in Tableau Desktop. The condition is offer status = hired, but offer status can contain my different response types. 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. Drag the State (group) dimension over the Region dimension on the Rows shelf to replace it. png - Ben-Sullins's library "Cannot blend the secondary data source because one or more fields use an unsupported. the count of claims I'm getting from the secondary data source, by counting distinctly a measure called claimid. Unknown file type Total from Secondary Data Source. However, when the linking dimension is not in the view, non-additive aLoading. LOD expressions are used when running complex queries with multiple dimensions at the data source level. LOD calculation and blended data sources. I am trying to use the below formula instead of countd function because my data comes from Impala {FIXED [Machine Nr] : COUNT([Machine Nr] )} / {FIXED [Machine Nr] : COUNT([Machine Nr] )} This works fine when there is no secondary data source but when I blend with a secondary data source it grays out my sheet i. Think of this layer as the Relationships canvas in the Data Source page. To overcome this, I've added a filter straight into the data source and not in the view. Use a parameter with a calculated field to filter the secondary data source at the row level. Both Primary and Secondary data sources have duplicate rows due to multiple joins in data prep. Primary and Secondary sources in data blending. 0 but was disabled (greyed out) in 8. I am trying to create a waffle chart. Now you see a new group field listed in the Population data source (primary) called State (group). I thought about using a parameter but you cant search with a parameter in a prompt, on the other charts that are like this there are hundreds on items. Case 2: If you are done with the dashboard development then create a empty extract and publish it on server and run the refresh so that data gets loaded. Credits to Jonathan Drummey for the below workaround Cannot blend the secondary data source because one or more fields use an unsupported aggregation . In a blend, the secondary data source can only contribute aggregated values using the level of detail defined by the linking fields that appear in the view, so when you remove them, the. Some examples include: session cookies needed to transmit the website, authentication cookies, and security cookies. e. I am trying to blend the same data against the other because I wanted to show Same Period last Year. ) A LOD calc is also trying to do stuff at the row level. 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. With the release of Tableau 8. The default view that you first see in the Data Source page canvas is the logical layer of the data source. If the user select May 2018. The "Create Primary Group" operation is bringing the dimension from the secondary into the primary, but it is static, and does not update when your data updates. - Dataset 1, records the amount spent on ads as "Cost" - Dataset 2 records the revenue generated by orders as "Proj. As you can see I have 2 different data sources using a blend on the blood type. Please check the attached workbook for details. Sometimes , it's automatically working but sometimes it says 'Unsupported Aggregation' . Because data blending is an ad-hoc LEFT join that aggregates data from the secondary data source, Tableau cannot always perform aggregations that require the full domain. Upvote Upvoted Remove Upvote Reply. 5 3 . Data blending works like a ___ join. The data are sorted, but each row only shows one month of data with the other five columns blank. I am trying to . Whichever data source you "use first" in a view (by dragging in a field) becomes Primary. the branch field I'm using from the primary data source. amount into the view, it gives me the correct sum. Overall LOD will show correct result in Primary datasource. e. The data source with the KMs is the primary source. When I do the join between the SSAS Tabular Model (primary data. Tableau has two inbuilt data sources named Sample-superstore and Sample coffee chain. It is important to understand which is the primary source, it can impact your view. e. But the source calc is a countD. For example, COUNTD(). I tried data blending keeping File C as primary and A & B as secondary data source with DD number as relationship. In this source create a calculated field to pull out the KMs on the date of oil change. 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 . ×Sorry to interrupt. In the Data window, right-click the relevant field. In order to create the waffle chart I am blending it with another datasource using the calculated field defined as [Week 5 (Week5Bond)]. I noticed that when the spatial file is the secondary data source, I cannot area plot it by double clicking the geometry variable. 2) DB2 blending doesn't support non-additive aggregates like COUNTD() from secondary sources. Chicken + Choice of Drink1 pc. The two data sources are identical. If I remove the blend, I cannot use/filter the secondary data source, and If I use the blend, it will display only the values for the first data source, but not from the second one, excluding. 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. This would be a great time saver, with all of the calculations and linking changing as well. I get error: “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. It has data from 2003-2012. ODBC is a pretty universal technology for doing this, you can find more by doing a web search on "linked tables" or "linked worksheets" for your specific data sources. The problem is when I try to calculate the median of that same measure. drag the secondary measures to measure values section . To blend on summary data, you can do the following: Create a. Option 2: Join tables that are in the same data source, instead of blending them. Secondary data source has Order Date represented as separate Year and Month fields. 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. Instead, publish. ) If only one of the tables requires row level information, consider making that the primary data source in the blend (I. 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. In blending data source, I try to slove problem but I can't. Loading. I would like to visualize number of distinct hardware. To blend on summary data, you can do the following: Create a. . Show moreA workbook or mock data would be a sure thing to comment and try upon 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. Blending with CountD and LODs. The default view that you first see in the Data Source page canvas is the logical layer of the data source. order_date = B. Fixed, countd functions won't work with the secondary datasources. Thanks. In the Data pane, select the Store - North data source. Instead, publish each data. 2. 1. But I cant add filter Month from the Budget Excel file. 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. 3. Cannot blend the secondary data source since one or more search use certain unsupported aggregation. Call it [Start KM]: IF ATTR ( [KM Date])=ATTR ( [OIL]. 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. We don't get row-level data from secondary sources on a blend. The chart should display: countd. 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. Status, Stage, etc). the count of claims I'm getting from the secondary data source, by counting distinctly a measure called claimid. Cannot Blend Secondary Data Source - 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. FIXED ID, WEEK: CountD (accounts)). Tableau Community (Tableau)Data blending creates a link on common dimensions--where those commonalities do not exist in the two data sources, values will be excluded. Trying to do a COUNTD() from a secondary data source and got this dreaded error: > Cannot blend the secondary data source because one or more fields use an unsupported aggregation . newBranchProjection (Secondary) When I try to add COUNTD([DistrictId]) from my primary to text table. Ambiente. I've tried using COUNTD() ID First Last 1 Jim Carrey 1 Jim Carrey 2 Liam Neeson 3 Wynona Ryder COUNT([ID]) = 4 COUNTD([ID]) results in error I can add to filters from the data extracts. Use blends when:. Upvote. If that does not help,. First data source looks like below. Data blending tools can present their findings as visualizations, such as infographics and charts, after querying data sources and aggregating relevant information. Therefore it cannot display null data. . I am using blending and created Relationship but i am having problem in terms of getting distinct count from one of the data sources. See the attached updated workbook. This is a new complexity in Tableau v8: In v7 and earlier, to blend we had to have the linked dimensions in the view, i. You can also define the relationship manually by right-clicking on the data source name in the Data pane, and selecting Relationships. Cannot blend the secondary data source because one or more fields use an unsupported aggregation It’s cable reimagined No DVR space limits. Fee". Hi All, Is there a way to use a parameter to work for secondary data source in blending. Resolution. Seemingly simple task is getting complicated in Tableau . when I use A as primary data source and drag A. In short, Tableau connects to multiple data sources, sends independent queries to those data sources, and then combines (or “blends”) the aggregated results of the independent queries on a single worksheet. ” Causes and Workarounds for a Blending Limitation Errors. Data source A has Role Column and Data source B also has Role Column. Secondary data sources cannot have logical tables (except when they satisfy specific conditions). They must be in the same format. The problem I'm running into is when I use another data source as the primary source and attempt to bring over the LOD calculation from a secondary source. Beyond that personally I tend to do the work necessary to avoid using data blending in production data sources & views. In versions prior to 2020. A datetime field may be converted to a date field using a calculation to remove the time portion. In the Data window, switch to the [data name2] data source. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Data blending brings in additional information from a secondary data source and displays it with data from the primary data source directly in the view. Are you talking about Tableau Prep or Tableau Desktop? Any chance you can share a sample of your data? Expand Post. I am trying to use the below formula instead of countd function because my data comes from Impala. The unsupported aggregation happens when your aggregate requires row-level visibility to the secondary data source. Data blending have some limitations regarding non-additive total such like COUNTD, MEDIAN, and RAWSQLAGG. on Rows, Columns, Pages, or the Marks Card. with blends, we are only able to support aggregates (like SUM, MIN, MAX. 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). Set up the primary and. This is a table calculation equivalent of the COUNTD() database function, which may be required either because the result needs to be used in a calculation at a different level of detail to the level at which it is calculated, or because the datasouce. I receive this error: "Cannot blend the data source because one or more fields uses an unsupported aggregation". This. Just aggregates (like SUM, MIN, MAX. So yes, in [Actual Hrs] you can only use the value from the secondary as an aggregate, and that's why you see: SUM([Networkdays (Test blend data calculation)]. Date dimensions: For cube data sources, date dimensions are typically organized into hierarchies that contain levels such as year,. LOD (exclude) - Filtering using a different data source I've used LOD (exclude) to create a % of total calc field (and then created a moving average off that). Drag the 2016 Population measure to the Columns. It also means you cannot create a workbook using the. Hi All, I have blended primary and secondary data sources. In the calculation dialog box, do the following: In the name text box, enter Sales for Store - South. In this source create a calculated field to pull out the KMs on the date of oil change. Think of this layer as the Relationships canvas in the Data Source page. Upvote Upvoted Remove Upvote Reply. I am trying to blend the same data against the other because I wanted to show Same Period last Year. I need to get a count distinct of Patient ID from the Primary data source, as well as count distinct of Patient ID from the Secondary data source in one worksheet. " The only fields used in the view are the date fields, to which I did a . Make the data source that contains the field that you want to use in the URL action the primary data source in. 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. Cannot blend the secondary data source because one or more fields use an unsupported aggregation issue. ODBC is a pretty universal technology for doing this, you can find more by doing a web search on "linked tables" or "linked worksheets" for your specific data sources. Currently, I have to rebuild the worksheet and bring in the secondary source first. Left. If we are working with one data source that is not relatable or joinable (such as Google Analytics) you are not able to blend a secondary data source with logical tables to it. duplicate the date field. If I cant go the above way then is there a possibility to do the duration calculation using table calculations or some other way. The Products set contain the individual products within an Opportunity whereas the Opportunities set contain Sales metrics (i. So, in the dummy data, there are two tables from two data sources. The secondary data source need to be my transaction file and primary data source need to be my budget file. ×Sorry to interrupt. This is the final step and will result in filtering between the blended data sources at your desired level of granularity. Also, in the attached I have added both Calc1 and Calc2 to the tooltip in Sheet 9. Jim. I am just trying to filter every Data source, by choosing a field that every Data source has. A datetime field in the primary data source, for example, will not blend with a date field in the secondary data source. Next, create a table calc using the [Start KM] to calculate the total KMs: from Primary data source from Secondary data source. The blend applies to that worksheet only. We have a calculated filed where an aggregation (COUNTD) is done on a filed of secondary data source. This is interesting. you get all data from main data source and ONLY matching data from secondary data source. Resolution. From Primary Data Source drag the measure names and measure values . Better collaboration. Verify if one of the measures coming from the cube data source has a default aggregation different than SUM, MIN, MAX, COUNT. The only workaround I can think of is to put the course code onto the level of detail shelf, but that means that what appear to be solid bars are actually stacked bars. [OIL DATE]) THEN MIN ( [KMs]) END. Russell Christopher (Member) 10 years ago. Please see if it helps , here it says that problem is with COUNT & they have provided one alternative way as well . Fields cannot be used from the [name of secondary data source] data source, because there is no blend relationship to the primary data source. Error: Cannot Blend the secondary data source because one or more fields use an unsupported aggregation.