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

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

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.