Forum Discussion

gauravjain119's avatar
gauravjain119
Frequent Visitor
8 years ago

Cummulative total displaying average rating value based on count of ratings

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 ...
v-juanli-msft's avatar
v-juanli-msft
Community Support
8 years ago

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's avatar
gauravjain119
Frequent Visitor
8 years ago

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's avatar
    v-juanli-msft
    Community Support
    8 years ago

    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