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

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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      So i've updated and uploaded the PBIX that i'm working with right now. Taking after the pattern that you showed me, but also adding my VAR _group = SelectedValue(Scores[Group]) filter in the calculate.
      https://drive.google.com/file/d/1Rl7QuiEjyoJ282zdYb_X7YHZmTYRjZ8K/view?usp=sharing

       

      I hope I laid it out in a way that makes sense so you can see the issue i'm currently having.

       

      I moved group F to the bottom of the page as an example. In the filters pane you can adjust the "rounds" that are in the calculation and the "Qualified" column updates accurately. As well the "Qualified After ..." work according to plan. When filtered down to a group.

       

      But if i try to total up the number of qualified teams I get:

      Which may just be a ranking order issue except if i switch from ASC to DESC I get

      Which is unfortunately, backwards. Now instead of checking for 1's and 2's for qualification I could check for 3's and 4's, but i'm worried it points to a larger issue in how I'm calculating.