No announcements

### Distinct count across multiple fact tables

I'm trying to get a distinct count measure working across multiple fact tables and can't figure out how to do it. Here is my ...
| 5 Replies | 1404 Views | Created by ScottT003 - Thursday, April 18, 2019 1:49 PM | Last reply by ScottT003 - Tuesday, April 23, 2019 1:18 PM

### Distinct count accross two tables fact?

others dimensions.   I want to count(Distinct(Product_Key) ... in my case the result is:
| 2 Replies | 4132 Views | Created by Bohor - Monday, October 20, 2008 12:11 PM | Last reply by Bohor - Tuesday, October 21, 2008 7:28 AM

### Distinct count for multiple fact tables in the same cube

;The users are looking for a distinct count of patients in all 4 fact tables.   What is the best way to accomplish this so that my cube does ...
| 1 Replies | 1252 Views | Created by AndyMN - Thursday, June 12, 2014 3:24 PM | Last reply by Elvis Long - Monday, June 16, 2014 6:06 AM

### Distinct count Id in fact

Hi Will, Thanks for answering. I'm trying to get a distinct count from dimension ...
| 4 Replies | 725 Views | Created by Caio R - Tuesday, September 24, 2019 8:22 PM | Last reply by Caio R - Friday, September 27, 2019 3:53 PM

### DAX: Distinct count across 2 tables/columns?

DB, which I import through PowerQuery into PowerPivot. The issue is that I need to calculate a distinct count of users (based on a user_fk) involved in EITHER transaction ...
| 2 Replies | 3445 Views | Created by Fidlefadle - Tuesday, July 26, 2016 3:17 PM | Last reply by Fidlefadle - Tuesday, July 26, 2016 6:05 PM

### MULTIPLE DISTINCT COUNT PROBLEM

But DISTINCT COUNT aggregation type does not work properly for these two measures. This aggregation considers just DISTINCT COUNT values of the specifed ...
| 1 Replies | 3505 Views | Created by innocent1973 - Tuesday, June 28, 2011 3:34 PM | Last reply by Jerry Nee - Thursday, June 30, 2011 6:20 AM

### DISTINCT() Across Multiple Fields

to filter for multiple customers and locations and it will always return the correct data. I'd like to create this in PowerPivot using DAX, but I can't find a way to get ...
| 1 Replies | 5358 Views | Created by Eric C Ness - Friday, December 9, 2011 3:44 PM | Last reply by Javier Guillen - Friday, December 9, 2011 7:07 PM

### Multiple Fact Tables

from the fact tables in the diagram in the centre pane to the measures list. If you cannot even see these columns in the diagram then you must have altered your table structures ...
| 2 Replies | 4846 Views | Created by kj3 - Monday, August 20, 2007 2:22 AM | Last reply by kj3 - Monday, August 20, 2007 3:42 PM

### distinct count with multiple partitions?

Distinct Count measure will work fine with multiple partitions. AS keeps the distinct count values inside the partitions, and therefore it can correctly ...
| 3 Replies | 7357 Views | Created by Arjun B - Wednesday, January 3, 2007 10:01 PM | Last reply by Arjun B - Thursday, January 4, 2007 11:05 PM

### MULTIPLE DISTINCT COUNT Problem

Hello Again, I am now able to get correct inventory stock levels of each product. But DISTINCT COUNT aggregation type does not work properly for these two ...
| 2 Replies | 4203 Views | Created by innocent1973 - Wednesday, June 22, 2011 9:08 PM | Last reply by Eileen Zhao - Tuesday, June 28, 2011 3:14 PM

### Get distinct results across two similar tables

both tables.  I'd like a query that will give me the DISTINCT records from both.  This is what I came up with but I have feeling there's a cleaner way with a ...
| 2 Replies | 903 Views | Created by Matt S- - Friday, August 2, 2013 5:49 PM | Last reply by Matt S- - Friday, August 2, 2013 5:54 PM

### HierarchyID Across Multiple Tables

Hi, I am looking for some advice on using HierarchyID across multiple tables.
| 1 Replies | 8408 Views | Created by Brian O'Donnell - Friday, July 9, 2010 2:54 PM | Last reply by SQLEnthusiast - Tuesday, July 13, 2010 9:55 AM

### Distinct count of dimension business key in fact table

If you have to distinct count an attribute in a SCD 2, you might choose between: Denormalizing that attribute in the fact table, and the create ...
| 2 Replies | 1649 Views | Created by AndyMN - Wednesday, June 18, 2014 2:29 PM | Last reply by Marco Russo - SQLBI - Thursday, June 19, 2014 7:52 AM

### Several Distinct Count measures in the same fact table?

should be fine to have min and distinct count (but for performance reason, it may be better to separate them), but I don't think it is possible to define multiple ...
| 8 Replies | 9242 Views | Created by Luis Simões - Tuesday, December 18, 2007 11:41 AM | Last reply by Tomik123 - Wednesday, February 8, 2012 8:36 AM

### Comparisons across multiple tables

User981378579 posted Hi All, I would like to set up a series of validations across several tables that aren't necessarily displayed on the ...
| 4 Replies | 2 Views | Created by Anonymous - Wednesday, March 26, 2008 6:45 PM | Last reply by Anonymous - Monday, March 31, 2008 6:54 PM

### Problem relating multiple fact tables

I have 2 fact tables in my cube (Encounter and Visit).   Every visit has at least 1 encounter but not every encounter has a visit.  I also have a department dimension which ...
| 1 Replies | 1237 Views | Created by AndyMN - Tuesday, May 13, 2014 8:27 PM | Last reply by Ken in Tampa - Wednesday, May 14, 2014 1:01 AM

### Role Playing dimension among multiple fact tables

I am modelling cube in SSAS. Cube has around 20 dimensions and 6 fact tables. Some of
| 2 Replies | 856 Views | Created by ANREV107 - Wednesday, October 28, 2015 2:12 PM | Last reply by Tom Phillips - Wednesday, October 28, 2015 5:47 PM

### Distinct Count

I have a data model with 2 tables, the data table and the calendar table. There is a calculated field that counts the customers by year using the distinct count and ...
| 2 Replies | 890 Views | Created by Otto Knoke - Monday, January 18, 2016 2:45 PM | Last reply by Tomas Ludvik - Tuesday, January 19, 2016 9:35 AM