Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Difference Between ALL and VALUES direction

So my last question about the World Cup was maybe too involved so i'll try breaking it up into smaller pieces.  I have 2 table visualizations: Where one is just a subset of the other and ...
Need Help
  • AntrikshSharma's avatar
    AntrikshSharma
    6 years ago

    Modified your measure to this:

    Phase1_GD_Ranking = 
IF (
    HASONEVALUE ( Scores[Team] ),
    RANKX (
        ALLSELECTED ( Scores[Group], Scores[Team] ),
        CALCULATE ( SUM ( Scores[Goal Differential] ) ),
        ,
        DESC,
        SKIP
    ),
    BLANK ()
)
AntrikshSharma's avatar
AntrikshSharma
Community Champion
6 years ago

Is this your desired result?

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    It appears so! Just reversed, but that's probably an easy fix if you used rankx. 

    how? 

     

    I'm literally on the edge of my seat here. I've been banging my head against the wall for 3 days.

    • AntrikshSharma's avatar
      AntrikshSharma
      Community Champion
      6 years ago

      Modified your measure to this:

      Phase1_GD_Ranking = 
IF (
    HASONEVALUE ( Scores[Team] ),
    RANKX (
        ALLSELECTED ( Scores[Group], Scores[Team] ),
        CALCULATE ( SUM ( Scores[Goal Differential] ) ),
        ,
        DESC,
        SKIP
    ),
    BLANK ()
)
      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        So i can work with this. Thank you so much! 
        But if i could indulge you for one more question.

        This result returns this for the whole table:

        Which is expected. How can i make a similar but different expression so i get the 1-4's in the goal differential column on the full table. Basically just stack all those results on top of each other?