Forum Discussion

3 Replies

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    7 years ago

    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's avatar
      Amz_123
      Helper I
      7 years ago

      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's avatar
        v-jiascu-msft
        Microsoft Employee
        7 years ago

        Hi Amz_123 ,

         

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

         

         

        Best Regards,