Forum Discussion

Brianoreilly's avatar
Brianoreilly
Icon for Helper II rankHelper II
8 years ago
Solved

Aggregating based on 2 Groupings

Hi All,   I have a scenario where I need to calculate the "% of Projects that meet our Customer Satisfaction Score" of greater than or equal to 5 and show the result in a Card Visual. This needs to...
Need Help
Tutorial Requests
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    8 years ago

    Hi Brianoreilly,

     

    You can create new calculated column below: 

     

    Date(M-Y) = FORMAT('Table1'[Date],"MMM") & "-" & YEAR('Table1'[Date])

     

    Then create a measure to return project satisfaction: 

     

    Project Satisfaction = var temp=SUMMARIZE('Table1','Table1'[Date(M-Y)],'Table1'[Project],"Ave",AVERAGE('Table1'[Satisfaction Score]))
    return
    DIVIDE(COUNTX(FILTER(temp,[Ave]>=5),[Ave]),COUNTROWS(temp))

     

     

    Best Regards,
    Qiuyun Yu 

TomMartens's avatar
TomMartens
Icon for Super User rankSuper User
8 years ago

Hey,

 

please provide the data in an easy to reproduce format by preparing a pbix file upload the to onedrive or dropbox, and share the link here.

 

Regards

Tom

  • Brianoreilly's avatar
    Brianoreilly
    Icon for Helper II rankHelper II
    8 years ago

    Hi Tom, 

     

    Thank you so much for the assistance. 

    I really appreciate it. 

     

    The solution provided by the moderator actually worked and meets my needs. 

     

    Thanks again, 

    Regards,

    Brian.