Show grand total as a new column

[Tasos]

Hello,

I have a relatively easy question (I guess) that I cannot find the solution.

In the table below, I want the last column (TotalActiveDays) to show the total number of days (252) in each line, as I am showing

Thanks

[tex628]

Or when i'm looking at this more closely, do you want the totalactivedays to reflect the highest value of activedaysorderbase? 

[Tasos]

Thanks for the answers.

I don't want the totalactivedays to reflect the highest value. In this example, the highest is 251 whereas the total is 252.

Additionally, I don't want to equal it with a specific value as a column because I want it to be dynamic when I am refreshing the database. For example, if another dataset has 300 distinct active days, I want the TotalActiveDays column to have the value 300 in each row.

Therefore, I guess I need to do that with a measure like:

TotalActiveDays = CALCULATE( DISTINCTCOUNT(OrderBase[OrderDate]),XXXXX)

[tex628]

Play around with Measure = Distinctcount(all(Table[Column]))

Since i cant view your dataset i cant really specify which column you should count the rows of! 

 / J

[Tasos · Accepted solution]

What you propose is not working.

What I have done though, is to create a new table named "Dates" summarising the dates 

dates = DISTINCT(OrderBase[OrderDate])

and then I have created a measure to calculate them

GrandTotalActiveDays = COUNT(dates[OrderDate]) 

Not sure if it is the optimum way, however it worked

[tex628]

Right, it's been a long day... Distinctcount is for columns and distinct for tables. 

That should work, glad it worked out! 

/ J

[tex628]

Create a calculated column and equal it to 252 then display that column in the visual. The column should be in the same table as SKU. 

This should work if 252 is a constant, if it needs to be dynamic in some way you will need a different formula.

/ J