No announcements
Found 2237019 threads
-
0 VotesNeed expression for conditional count on a group total count
I want to hide the group rows which had the expressions that called the code to add count.Answered | 3 Replies | 6852 Views | Created by HariAdu - Wednesday, July 11, 2012 2:47 PM | Last reply by Jason Tom Thomas - Thursday, July 12, 2012 1:31 PM
-
1 Votes
Count with Condition
0Answered | 4 Replies | 4368 Views | Created by Sumanfbc - Saturday, November 20, 2010 8:21 AM | Last reply by Sumanfbc - Saturday, November 20, 2010 9:51 AM -
0 Votes
Counting Conditions
Do you know - can point to some blog explaining why sum(case when Condition then 1 else 0 end) performs worse than count (case when Condition then 1 ...Answered | 8 Replies | 2565 Views | Created by imdandman - Wednesday, October 26, 2011 3:19 AM | Last reply by Naomi N - Wednesday, October 26, 2011 2:43 PM -
4 Votes
Count(Sum(Total))
Hello team, What could be placed in parentheses in front of over in: Count(Sum(Total)) Over() ?Answered | 8 Replies | 1041 Views | Created by cloudsInSky - Friday, July 13, 2018 5:34 AM | Last reply by Jingyang Li - Thursday, July 19, 2018 2:17 PM -
0 Votes
Total count with filter and without grouping
The row function can take multiple name/expression pairs, so the following pattern should work evaluate ROW ( "first quarter" , CALCULATE( ...Answered | 2 Replies | 683 Views | Created by SH_2017 - Sunday, December 10, 2017 10:08 AM | Last reply by willson yuan - Monday, December 11, 2017 2:53 AM -
0 Votes
Count If Conditions in program
Ali Muhammad, Shafiq is almost there but you need to remember a few things: If you have multiple classes in a namespace you need a ...Answered | 2 Replies | 485 Views | Created by Ali Muhammad Nizamaani - Friday, February 12, 2016 12:30 PM | Last reply by Ken Cenerelli - Friday, February 12, 2016 7:19 PM -
1 Votes
Report Builder - Count totals
For this, you need to group the table and specific the group name for the count expression.Answered | 1 Replies | 726 Views | Created by SandeODF - Tuesday, August 13, 2019 3:41 PM | Last reply by Lukas DreiKlein - Wednesday, August 14, 2019 3:08 AM -
0 Votes
Passing the total count to a parameter
Hi jmbuena, According to your description, you want to count the parent category and subcategory, then perform division for those two values.Answered | 2 Replies | 1038 Views | Created by jmbuena - Saturday, April 18, 2015 12:36 AM | Last reply by Qiuyun Yu - Monday, April 20, 2015 9:11 AM -
0 Votes
Select-Count-Having need another condition
1 order by name RESULTS: -------- John 2 ESHANI.Answered | 3 Replies | 2424 Views | Created by bommer871 - Thursday, August 16, 2012 8:01 PM | Last reply by Eshani Rao - Friday, August 17, 2012 1:33 AM -
0 Votes
Total count for several ForEachLoops
I would then have a fourth variable that would sum the three through an expression.Answered | 2 Replies | 4030 Views | Created by TEN_ATL - Tuesday, February 10, 2009 2:52 PM | Last reply by Eric Wisdahl - Tuesday, February 10, 2009 4:13 PM -
0 Votes
Conditional Counting of a value from table
Add the "Salesperson" and “Date” as row groups in Matrix 3.Answered | 4 Replies | 1056 Views | Created by GarinTiger - Tuesday, March 12, 2013 5:33 PM | Last reply by Fanny Liu - Monday, March 18, 2013 7:40 AM -
5 Votes
How to group by count with condition in powerquery
5.Answered | 3 Replies | 966 Views | Created by AlexMartini - Thursday, August 4, 2016 11:24 PM | Last reply by geraldartman - Wednesday, September 7, 2016 6:46 PM -
0 Votes
Conditional count
My query just outputs the total function change count per employee...Answered | 6 Replies | 3054 Views | Created by avanrijn - Thursday, September 8, 2011 1:36 PM | Last reply by Uri Dimant - Thursday, September 8, 2011 3:10 PM -
0 Votes
how to count characters in all rows and count total count ?
When I use the sample data, all I get is a single row with NULL in all columns except the column note which has the value Total Count.Answered | 13 Replies | 861 Views | Created by srajmuneer - Monday, April 10, 2017 2:25 PM | Last reply by srajmuneer - Wednesday, April 19, 2017 6:01 PM -
0 Votes
Count + Group By return total number of rows
You could use your query as a derived talbe: select count(*) as cnt from ( HERE GOES YOUR QUERY ) as T; AMB ...Answered | 1 Replies | 4341 Views | Created by Scott_P - Monday, September 17, 2012 7:31 PM | Last reply by Hunchback - Monday, September 17, 2012 7:36 PM -
0 Votes
Counting Groups Within Groups
: Select PdNumber, Severity, count(severity) as AgencyByType from from tblCsCases where IssuedDate BETWEEN '20160101' AND '20161231' group by PdNumber, ...Answered | 5 Replies | 716 Views | Created by Kurt Woodfin - Friday, January 27, 2017 5:19 PM | Last reply by Kurt Woodfin - Friday, January 27, 2017 7:00 PM -
0 Votes
Group and Count
., Count = y.logs.Count()) I get the error: Cannot convert lambda expression to type ...Answered | 5 Replies | 1367 Views | Created by MDMoura - Monday, October 22, 2012 1:37 PM | Last reply by MDMoura - Monday, October 22, 2012 8:48 PM -
0 Votes
Counting Age Groups
I have a table of Individuals that I would like to have a total count of age ranges in separate columns.Answered | 5 Replies | 1152 Views | Created by Darnell - Friday, April 5, 2013 4:48 PM | Last reply by Darnell - Friday, April 5, 2013 5:32 PM -
0 Votes
How to display the count of column groups.
I need column count in order as shown below.Answered | 7 Replies | 809 Views | Created by Palani_M - Wednesday, October 14, 2015 7:13 AM | Last reply by Palani_M - Thursday, October 15, 2015 9:37 AM -
2 Votes
DAX Count and Sum functions with condition
CALCULATE( <expression>, <filter expression> ) is a very powerful and basic building block in DAX.Answered | 4 Replies | 5103 Views | Created by Grace Bite - Thursday, June 6, 2013 10:28 PM | Last reply by Moyz Khan - Thursday, July 24, 2014 7:28 PM - Items 1 to 20 of 2237019 Next ›
No announcements
