Ignore visual filter for a chart

[Anonymous]

Hello 

A have a flat data table related to some running times and postions example of it is below

RaceNumber	Position	Time(mins)	Name
1	1	20	Bob
1	2	21	John
1	3	22	Jane
2	1	18	Sally
2	2	19	Tim
2	3	23	Anne

I am trying to a get distribution of the time (mins ) columns based on the postion the runners comes 

example something like this

I have a filters on the page for racenumber and position. For this i want the filter on the racenumber to be ignored

My measure for

Total runs = 

CALCULATE(COUNTROWS('All Race Data'),

ALLEXCEPT('All Race Data','All Race Data'[RaceNumber]))

Can someone help me out with what i am doing wrong

[dedelman_clng]

Hi @Anonymous  - try moving the filter on your table inside the COUNTROWS function

Total runs =
CALCULATE (
    COUNTROWS ( ALLEXCEPT ( 'All Race Data', 'All Race Data'[RaceNumber] ) )
)

If that doesn't work, please share your pbix with sensitive data removed.

Hope this helps

David

[Anonymous]

@dedelman_clng Thanks for your suggestion but it did not work

This is what i currently have. I want it to see the mintue distribution for any selected overall position, i don't want the racenumber filter to have any effect on the visual. I understand i can use edit interactions - just hoping to find a dax solution

Here I am using the measure 

Total Runs = COUNTROWS(AllRaceData) 

which works - provided you have all racenumbers selected

I have tried your suggestion

Total Runs ALL =

CALCULATE (

COUNTROWS ( ALLEXCEPT ( AllRaceData, AllRaceData[RaceNumber] )

))

But it didn't work

I have an editted version of the pbix as you have suggested. 

I can't figure out how to upload it here?

[dedelman_clng]

Hi @Anonymous - as far as the report file goes, put it on a sharing site (onedrive, google, Dropbox, etc) and provide the link in your post. 

David

[Anonymous]

Okay thanks @dedelman_clng 

Here is the pbix file here

https://www.dropbox.com/s/nzyosfv8yysjtms/5km%20run%20edit.pbix?dl=0