The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now
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,
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,
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.
Hi @Amz_123 ,
Can you share a small sample, please? Please mask the sensitive parts.
Best Regards,
Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.
User | Count |
---|---|
158 | |
106 | |
96 | |
83 | |
75 |
User | Count |
---|---|
154 | |
137 | |
131 | |
81 | |
62 |