No announcements
Found 1765418 threads
-
0 VotesSSAS - Multiple distinct counts
but i want two distinct counts in one measure group. we have a cube through excel and it will confuse users have two different measure ...Answered | 3 Replies | 6681 Views | Created by kiwiNspain - Wednesday, September 21, 2011 8:39 PM | Last reply by Darren Gosbell - Thursday, September 22, 2011 4:50 AM
-
0 Votes
Problem with getting distinct count to work
Hi, If I understand the original post correctly, then the solution is a bit more complex: Your proposed solution would deliver the distinct count of customers when ...Answered | 4 Replies | 4126 Views | Created by pschouten - Tuesday, June 30, 2009 12:21 PM | Last reply by pschouten - Thursday, July 2, 2009 4:18 PM -
1 Votes
Distinct Count
i think your problem is ... you are doing something slightly different in your crystal code above vs your sql code below ...Answered | 2 Replies | 5949 Views | Created by Milton Waddams - Wednesday, July 16, 2008 3:43 PM | Last reply by neonprimetime - Thursday, July 17, 2008 3:42 PM -
0 Votes
MDX DISTINCT COUNT Total problem
Dear Martijn, Adding a distinct count measure (in its own measuregroup) based on the Customer number (or id) did the ...Answered | 11 Replies | 4770 Views | Created by L_HK - Thursday, September 29, 2011 2:31 PM | Last reply by L_HK - Monday, October 3, 2011 3:56 AM -
0 Votes
Distinct Count
You can add as many distinct count measures to a cube as you like using different measure groups and your are not limited to the existing Measure Groups of your cube.Answered | 3 Replies | 4715 Views | Created by SSAS BT - Saturday, May 22, 2010 11:52 AM | Last reply by Cees van Diermen - Sunday, May 23, 2010 6:01 PM -
0 Votes
distinct count
If you had a GROUP BY and the query returned, say, three rows without the DISTINCT.Answered | 1 Replies | 1011 Views | Created by kvd123 - Tuesday, March 1, 2016 10:01 PM | Last reply by TiborK - Tuesday, March 1, 2016 10:13 PM -
1 Votes
COUNT DISTINCT
use below query for your senario, select col1,col3,col4,count(*) from table group by col1,col3,col4SQL Champ Database Consultants ...Answered | 4 Replies | 2238 Views | Created by lrj19851 - Wednesday, December 19, 2012 4:02 PM | Last reply by Naomi N - Wednesday, December 19, 2012 5:08 PM -
0 Votes
Count(distinct)
Leave out the "distinct": SELECT ItemID, sum(Qty) as total, count(ItemID) as N From JobItems Group by ItemID Matthias Kläy, Kläy ...Answered | 2 Replies | 654 Views | Created by RonNewby - Friday, May 13, 2016 4:15 PM | Last reply by Deepak Saradkumar Panchal - Monday, May 16, 2016 2:07 AM -
0 Votes
Distinct Count
If you are creating a physical DistinctCount the measure needs to be in it's own measure group anyway, so just create a view or a named query in the DSV with a WHERE clause like "where ...Answered | 4 Replies | 3264 Views | Created by Aniruddha Thengadi - Tuesday, April 3, 2012 12:53 PM | Last reply by Aniruddha Thengadi - Thursday, April 5, 2012 11:39 AM -
0 Votes
Optimize count distinct for multiple groups of records
"count(distinct ...)Answered | 5 Replies | 908 Views | Created by Rob Kruis - Thursday, May 21, 2015 7:42 PM | Last reply by pituach - Thursday, June 4, 2015 10:41 AM -
0 Votes
Need multiple distinct counts, have 1 fact and 1 dimension
If you have measure1 and measure2 in measure_group1, and want to separate measure2 in measure_group2, do following: 1, create a fake measure using DISTINCT ...Answered | 5 Replies | 7474 Views | Created by Bartron2 - Friday, September 17, 2010 7:12 PM | Last reply by Coonlee - Saturday, August 5, 2017 10:33 AM -
1 Votes
Split distinct count into fractions of a count
But even though it is possible to do a fractional calculation, my suggestion would to create a document with the explanation about how ...Answered | 2 Replies | 1144 Views | Created by Madadd33 - Tuesday, July 26, 2016 3:35 PM | Last reply by Madadd33 - Friday, August 18, 2017 4:31 PM -
0 Votes
Query calculating distinct and then count
= 20 then 'x' else NULL end) as Count_gt_20 , count(case when Severity >= 10 and Severity < 20 then 'x' else NULL end) as Count_10_to_20 from ...Answered | 3 Replies | 1008 Views | Created by shadinbaig - Sunday, April 5, 2015 12:42 PM | Last reply by johnqflorida - Sunday, April 5, 2015 5:42 PM -
0 Votes
Distinct Count on a Measure
Best practice recommends a separate measure group for a distinct count measure - if you add a such a measure in BIDS, a separate measure group is created.Answered | 7 Replies | 3639 Views | Created by sunny2683 - Wednesday, December 23, 2009 2:45 AM | Last reply by Deepak Puri - Wednesday, December 23, 2009 3:03 PM -
4 Votes
Distinct Count
[Sales] ).COUNT; The count function could be useful since the issue I have is caused by Sum in the below formula.Answered | 18 Replies | 6250 Views | Created by BSaliba - Wednesday, April 6, 2011 10:54 AM | Last reply by BSaliba - Monday, April 11, 2011 9:17 AM -
0 Votes
MDX, Count, Except, Distinct
[Remise Facture]) )).Count / Nonempty( ...Answered | 5 Replies | 971 Views | Created by Kherrachi Med - Monday, May 14, 2018 5:24 PM | Last reply by willson yuan - Wednesday, May 16, 2018 1:01 AM -
0 Votes
Distinct count of parent IDs
Simply alter the set that the script is counting to count the Distinct() parents.Answered | 3 Replies | 2304 Views | Created by jschroeder - Wednesday, August 14, 2013 3:21 PM | Last reply by RichardLees - Tuesday, August 20, 2013 6:00 AM -
0 Votes
Excluding rows for distinct count
Right now, -1 value is also included in the distinct count which i wanted to get away with it.Answered | 5 Replies | 7017 Views | Created by Sambathraj - Sunday, November 15, 2009 10:07 AM | Last reply by Raymond-Lee - Wednesday, November 18, 2009 7:10 AM -
0 Votes
Distinct Count
There is a calculated field that counts the customers by year using the distinct count and everything works perfect.Answered | 2 Replies | 1238 Views | Created by Otto Knoke - Monday, January 18, 2016 2:45 PM | Last reply by Tomas Ludvik - Tuesday, January 19, 2016 9:35 AM -
0 Votes
How implement distinct count ?
If I understand you correct - "Currently there is no way to achieve distinct semantics' still actual ?Answered | 3 Replies | 7004 Views | Created by al.kozlov - Thursday, November 25, 2010 3:52 PM | Last reply by Allan Mitchell - Thursday, November 25, 2010 7:40 PM - Items 1 to 20 of 1765418 Next ›
No announcements
