Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Ignore visual filter for a chart

Hello 

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

 

RaceNumberPositionTime(mins)Name
1120Bob
1221John
1322Jane
2118Sally
2219Tim
2323Anne

 

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

4 Replies

  • dedelman_clng's avatar
    dedelman_clng
    Icon for Community Champion rankCommunity Champion
    6 years ago

    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's avatar
      Anonymous
      Not applicable
      6 years ago

      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's avatar
        dedelman_clng
        Icon for Community Champion rankCommunity Champion
        6 years ago

        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