How to create a calculated column with same value in every row with a calculated value

[Anonymous]

Hi,

I am trying to create a calculated column using DAX Calculate function.

I want all my rows to have the same value that was calculated using CALCULATE function.

I want all rows of thisFiscalWeek column to be populated with the outcome of CALCULATE function.

When I use this code it is only populating one row. I want that value to be in every row.

thisFiscalWeek = CALCULATE(MAX('Date Hierarchy'[fiscalWeek]), 'Date Hierarchy'[rDate] = 0)

Thank you for you help in advance

[some_bih · Accepted solution]

Hi @Anonymous 

picture is not visible- too small. Still, try v2 below

thisFiscalWeek v2 = 

CALCULATE(MAX('Date Hierarchy'[fiscalWeek]), 'Date Hierarchy'[rDate] = 0, ALL())