Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
104 | |
77 | |
67 | |
63 |
User | Count |
---|---|
144 | |
107 | |
105 | |
82 | |
69 |