Forum Discussion

Brianoreilly's avatar
Brianoreilly
Helper 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 

v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
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 

  • Brianoreilly's avatar
    Brianoreilly
    Helper II
    8 years ago

    Hi Qiuyun Yu , 

     

     

    Thank you so much for the solution. 

     

    There was no way in hell, I would of figured that out by myself. 

     

    Appreciate your diligent work. 

     

    Kind Regards, 

    Brian.