cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Amz_123 Regular Visitor
Regular Visitor

Dax

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,


2.png

3 REPLIES 3
Highlighted
Community Support Team
Community Support Team

Re: Dax

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,

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Amz_123 Regular Visitor
Regular Visitor

Re: Dax

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.



Community Support Team
Community Support Team

Re: Dax

Hi @Amz_123 ,

 

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

 

 

Best Regards,

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.