Forum Discussion

SteveIOW's avatar
SteveIOW
Icon for Helper II rankHelper II
4 years ago

Average of DistinctCount PCM

Dear all,   as you can see below I am trying to find the average of the last 6 months data. The data is loaded in as individual users and the date the access a website. I am countinf the number th...
Need Help
mh2587's avatar
mh2587
Icon for Super User rankSuper User
4 years ago
Average Per Country = 
VAR _A =
    SUMMARIZE (
        'Table',
        'Table'[Country],
        'Table'[Product],
        "DisC", DISTINCTCOUNT ( 'Table'[Color] )
    )
RETURN
    AVERAGEX ( _A, [DisC] )
// Modify it with your scenario
  • SteveIOW's avatar
    SteveIOW
    Icon for Helper II rankHelper II
    4 years ago

     

    mh2587 Forgive me but is this not exactly the same as I ahve put above but without the ALLSELECTED?

     

    • v-easonf-msft's avatar
      v-easonf-msft
      Icon for Community Support rankCommunity Support
      4 years ago

      Hi, SteveIOW 

      You can try to add dynamic reference lines to visuals with the Analytics pane in Power BI Desktop.

      Please select visual->go to Visualization Area -> Analytics -> Average Line 

      Use the Analytics pane in Power BI Desktop 

       

      Best Regards,
      Community Support Team _ Eason

      • SteveIOW's avatar
        SteveIOW
        Icon for Helper II rankHelper II
        4 years ago

        Thank you - my issue is that I am trying to create an SPC that rferences only the last 6 months for mean and sigma lines. the rference line visuals will only provide mean and sigma lines for the whole displayed data. I need it to display the lines across the whole data but using only the last 6 months in the calculation.

        any ideas?