Cummulative total displaying average rating value based on count of ratings

[gauravjain119]

Hello Team,

I have a data of suppliers who have been rated since last year.
I want to make a cummulative graph on the weekly basis.
I want to show the information about the number of suppliers who have been rated by 10 or more buyers 
Filters
suppliers receiving an average rating between
1-2
3-5
5-10.

can you provide me the Dax code or way how to do it... Below is my sample data

[v-juanli-msft]

Hi

Could you share some example data with a pbix?

“I want to show the information about the number of suppliers who have been rated by 10 or more buyers”, how to define the condition, should it be value in the “ranking” column which is large or equal 10?

Best Regards

Maggie

[gauravjain119]

Hello Maggie,

10 or more is the count of the ratings received by the supplier and in the screenshot shared above Ratings column provides the Rating which supplier has received For ex 2 is the rating which supplier has received from one buyer out of 5.
In the above example one supplier can receive multiple ratings from different buyer.

Regards,

Gaurav

[v-juanli-msft]

Hi @gauravjain119

Sorry for still having puzzle about your rule to create DAX formula.

From your statement and picture, I can’t see where is the “buyers”, “weekly basis” and I don’t understand what’s meaning of columns in the picture and which should be used.

As for your requirement, I can illustrate how to work out this kind problem.

“make a cummulative graph on the weekly basis”

Measure below

cummulative total =
CALCULATE (
    SUM ( Sheet1[average rating] ),
    FILTER (
        ALL ( Sheet1 ),
        [date] <= MAX ( [date] )
            && [weeknum] = MAX ( [weeknum] )
    )
)

Best Regards

Maggie