Forum Discussion

Anonymous's avatar
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...
Need Help
v-yulgu-msft's avatar
v-yulgu-msft
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's avatar
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's avatar
    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's avatar
      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,