Account by average result

[cinthya-er]

Hello,

I am facing a nesting problem, I have an application where I need to get the project account given the percentage obtained from an average of their interviewees, each project has a one-to-many relationship and the project count will depend on the average of each Project (From interviews).

I leave the example:

This is a graph with the Projects dimension

To get the account of projects by color is necessary to get the average rating by average and depending on the range make an account and get by rank the percentage.

=COUNT(DISTINCT {<Aggr(Avg([Rating]),Proyect)={">=0.9"}>}[Proyecto)

My formula is not working.

I hope you have already faced something similar and can help me to solve this small setback.

Regards!!

Cin ER

[sunny_talwar]

May be this

=Count(DISTINCT {<Proyecto = {"=Avg([Rating]) >= 0.9"}>} Proyecto)

[cinthya-er]

Thank you very much, I did not know that it could be evaluated within a set analysis, you saved my life