Forum Discussion
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...
v-yulgu-msft
Microsoft Employee
Microsoft EmployeeHi 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
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,