Forum Discussion

jtpiazzamn's avatar
jtpiazzamn
Icon for Helper I rankHelper I
3 years ago

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...
Need Help
ppm1's avatar
ppm1
Icon for Solution Sage rankSolution Sage
3 years ago

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

  • jtpiazzamn's avatar
    jtpiazzamn
    Icon for Helper I rankHelper I
    3 years ago

    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!