Dax

[Amz_123]

Hi Community,
Help me with DAX.
In column visual, How to display total count of week (53) irrespective of X axis (Week). In the Screenshot, Count of Week is displayed as 1.
Thanks in advance,

[v-jiascu-msft]

Hi @Amz_123 ,

Just see from your image, you need to clear the context of weeks like below.

Measure =
CALCULATE ( DISTINCTCOUNT ( 'Calendar'[WeekNum] ), ALL ( 'Calendar'[WeekNum] ) )

Or,

Measure 16 =
CALCULATE ( COUNT ( 'Calendar'[WeekNum] ), ALL ( 'Calendar'[WeekNum] ) )

Best Regards,

[Amz_123]

Hi @v-jiascu-msft ,

I tried but not getting the expected Result as X-axis in the Visual and Second Parameter in Calculate Formula is same, the result i am getting is 1 for all Week in X-axis.

[v-jiascu-msft]

Hi @Amz_123 ,

Can you share a small sample, please? Please mask the sensitive parts.

Best Regards,