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?

      • AntrikshSharma's avatar
        AntrikshSharma
        Community Champion
        6 years ago

        Can you please show what would the end result look like for the statement "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?"