Forum Discussion
Scatter chart help -
I'm trying to duplicate this scatter chart - I have all of the values calculated, but can't find the right scatter chart. X axis - this will display Names of reviewers y axis - this will display A...
It looks like it is not filtering on the Reviewer Name. Do you have a relationship in place between the table with the names and the table with the data?
Or your DAX measure is removing too many filters. Please share your DAX measure expressions, along with a description of your model (tables and relationships).
Pat
I added the Reviewer name to the table column via a formula. see below
ReviewerName =
VAR UserID = 'ArcWerx Ratings (2)'[Arcwerx.user.id]
VAR ARCWerxRevName =
MAXX(FILTER('User List w-competence','User List w-competence'[User.id]=UserID),'User List w-competence'[User.displayName])
RETURN
ARCWerxRevName
I changed the x axis to use the user ID and it looks better
The table only has 1 relationship - connected to a table with userID's to get the name of the user ID.
Here are the measures I'm using
Avg Diff from Mean = [Rev Avg Score] - [Rev Mean Score]
Rev Avg Score =
CALCULATE(
AVERAGE('ArcWerx Ratings (2)'[Arcwerx.value]),
ALLEXCEPT('ArcWerx Ratings (2)','ArcWerx Ratings (2)'[Arcwerx.suggestion.id],'ArcWerx Ratings (2)'[Arcwerx.user.id]
))
Rev Mean Score =
CALCULATE(
MEDIAN('ArcWerx Ratings (2)'[Arcwerx.value]),
ALLEXCEPT('ArcWerx Ratings (2)','ArcWerx Ratings (2)'[Arcwerx.suggestion.id],'ArcWerx Ratings (2)'[Arcwerx.user.id]
))
Thank you!