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 

dhusanth's avatar
dhusanth
Frequent Visitor
8 years ago

Hi,

 

I have an instance where i have to use Multiple Lines in secondary axis.

I am expecting to draw a chart like below in power bi, but i could find option. In the line and clustered column chart, i am able to get only one line in secondary axis.

 

Please help me on this.