Forum Discussion

Anonymous

Not applicable

9 years ago

Set total count as record count

Hi, I have a table where I calculate the count of days, but I want the total count in all rows and not only in the of the TOTAL at the bottom of the table, I have shared the pics of my current resul...

Microsoft Employee

9 years ago

Hi Anonymous,

I assume that you added the day column directly from table into visual and choosed 'count' aggregation which returned 1 for each row, right?

To display the total count in all rows, please add a measure into visual which is created as below:

Count of days = CALCULATE(COUNT('TableName'[Date]),ALL('TableName'))

Regards,
Yuliana Gu

Anonymous
Not applicable
9 years ago
Hi v-yulgu-msft
Thanks for your reply, I have used your DAX I get the desired output when I have only weekdays and Count of days, but when I include a column "Date" from Table 2 the values gets drilled down, but I want the same 731 as a result even when I include date column, is this possible with DAX?

Regards,
- v-yulgu-msft
  Microsoft Employee
  9 years ago
  Hi Anonymous,
  
  Actually, the count values will keep 731 even we add another column into visual. Please check whether you have used ALL function in DAX formula as I mentioned above. Besides, if it still doesn't work, instead of using a measure, you can create a calculated column with the same DAX formula.
  
  By the way, all above columns are from a single table, right?
  
  Regards,
  Yuliana Gu
  - Anonymous
    Not applicable
    9 years ago
    Hi v-yulgu-msft,
    The weekdays and Count of days columns are from Table 1 and "Date" column is from Table 2.
    I guess thats why I am not getting the desired o/p, How can I use the Table 2 columns also in side the formula.
    
    Regards,