Creating a measure to ignore filter context

[ViralPatel212]

Spoiler

Hello team and  @v-yiruan-msft 

I have a ranking measure called Dealer Ranking 3 and this measure identifies where the dealer "Barclays" is positioned and displays it.

However when i have a filter with client this measure gets sliced and shows where barclays is positioned for that client (per month) however i would like that measure not to change and jus show the Overall position.
Here is a sample file of the report: Sample file 

Here is the measure for Dealer ranking number 2 test:

Dealer Ranking Number 2 test = 
var _rank =  IF( [Ranking Size (Vol)] = blank(), BLANK(), RANKX(ALL('Dealer Ranking'[test 2],'Dealer Ranking'[test]),[Ranking Size (Vol)],,DESC,Dense))
VAR _tab =
    FILTER (
        ADDCOLUMNS (
            ALLSELECTED( 'Dealer Ranking'[test],'Dealer Ranking'[test 2] ),
            "@rank", [Dealer Ranking 3]
        ),
        [test 2] = "Barclays"
    )
VAR _rankbarclays =
    CALCULATE( MAXX ( _tab, [@rank] ),REMOVEFILTERS('Dealer Ranking'[Glimpse_buy_side]))


RETURN

_rankbarclays

Other measures used:

Ranking Size (Vol) = 

VAR _volumeall =
    CALCULATE(
        [Ranking Size],
        FILTER(
            'Dealer Ranking',
            'Dealer Ranking'[Type] = "Vol. (MM)"
        )
    )

VAR _volumeeur =
    CALCULATE(
        [Ranking Size (EUR)],
        FILTER(
            'Dealer Ranking',
            'Dealer Ranking'[Type] = "Vol. (MM)"
        )
    )

RETURN
    IF(
        ISFILTERED('Dealer Ranking'[Currency]),
        _volumeall,
        _volumeeur
    )


Dealer Ranking 3 = IF( [Ranking Size (Vol)] = blank(), BLANK(), RANKX(ALL('Dealer Ranking'[test 2],'Dealer Ranking'[test]),[Ranking Size (Vol)],,DESC,Dense))

[ViralPatel212]

@v-yiruan-msft 

any chance if you could solve my issue? 

Here is a sample file of the report: Sample file 

 

[sevenhills]

ALLSELECTED also can be used if you want to apply selected filter contexts.

https://radacad.com/power-bi-dax-all-vs-allselected

Your post need to be updated with sample data, and expected output. Hard to understand from code. 

[ViralPatel212]

Hello @sevenhills i have added a link in the original post where I have share the sample file. 

https://www.dropbox.com/scl/fo/8lbwxkv8mmkgs0albydtv/AIdE_uDnCJhDIChvExvVWuY?rlkey=kzhzcn961isqwveef...

[sevenhills]

I am able to see and download your 2 files - excel and pbix.

I assume that you want the measure to show the exact values irrespective of client selected for Barclays.

first part to get the volume is easy and working! slight modification of your volume metric used in the visual.

1. Measure Volume all clients = 
IF ( IsBlank([Client size Volume]), BLANK(),  
  CALCULATE( [Client size Volume], 'Dealer Ranking'[Counter Party] = "Barclays", REMOVEFILTERS('Dealer Ranking'[Glimpse_buy_side]))
)

When it comes to ranking, for some reason it is not working!

[ViralPatel212 · Accepted solution]

@sevenhills @Greg_Deckler 

I was able to resolve it! 

VAR _rankbarclays =
    CALCULATE (
        MAXX (
            FILTER (
                ADDCOLUMNS (
                    ALL('Dealer Ranking'[Counter Party], 'Dealer Ranking'[Counter Party Blanks]),  // Ignore all slicers/filters on Counter Party
                    "@rank", [Dealer Ranking Number 2 test]
                ),
                [Counter Party] = "Barclays" 
            ),
            [@rank]
        ),
        REMOVEFILTERS('Dealer Ranking'[Glimpse_buy_side])  // Explicitly removing filters on Glimpse_buy_side
    )

RETURN
    _rankbarclays

[sevenhills]

Glad to hear that it is resolved. 

[ViralPatel212]

hi @sevenhills 

i dont know why, i am stuck in the same situation as well.

[ViralPatel212]

hi @Greg_Deckler 

I have used the ALL function but it seem to not work

Dealer Ranking Number 2 test = 
var _rank =  IF( [Ranking Size (Vol)] = blank(), BLANK(), RANKX(ALL('Dealer Ranking'[test 2],'Dealer Ranking'[test]),[Ranking Size (Vol)],,DESC,Dense))
VAR _tab =
    FILTER (
        ADDCOLUMNS (
            ALLSELECTED( 'Dealer Ranking'[test],'Dealer Ranking'[test 2] ),
            "@rank", [Dealer Ranking 3]
        ),
        [test 2] = "Barclays"
    )
VAR _rankbarclays =
    CALCULATE( MAXX ( _tab, [@rank] ),REMOVEFILTERS('Dealer Ranking'[Glimpse_buy_side]))


RETURN

Calculate (_rankbarclays, ALL('Dealer Ranking'))

[Greg_Deckler]

@ViralPatel212 In _tab you are using ALLSELECTED not ALL. It's almost impossible to be specific here without sample data to recreate. 

Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

[ViralPatel212]

Hi @Greg_Deckler 

@I have posted a sample file in the original post. But you can download it from here 

https://www.dropbox.com/scl/fo/8lbwxkv8mmkgs0albydtv/AIdE_uDnCJhDIChvExvVWuY?rlkey=kzhzcn961isqwveef...

[Greg_Deckler]

@ViralPatel212 You can get your 2 base SUM measures to ignore client by doing this:

Ranking Size =

    CALCULATE( SUM('Dealer Ranking'[Size]), REMOVEFILTERS('Dealer Ranking'[Glimpse_buy_side]) )

However, try as I might, I can't get the Ranking Size (Vol) measure to remain constant when clicking on clients slicer.

[Greg_Deckler]

@ViralPatel212 Use ALL to override filter context.