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 ()
)
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?"

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Yeah if i change the measure you gave me a smidge:

        I can get this. Which is almost right just like before except 30,31,32 has a change to show up where 2-3-4 are supposed to be. If i filter that full table down to one group its fine.