Forum Discussion

newpi's avatar
newpi
Icon for Helper V rankHelper V
6 years ago
Solved

Filter to show data at aggregate level not row level

Hi,   I have a dax measure for total duration. Right now its a filter on a table visual which has user name & Activity & total duration as fileds . So when I Filter the table with saying duration >...
Need Help
Show and Tell
Tips and Tricks
  • v-lili6-msft's avatar
    v-lili6-msft
    6 years ago

    hi newpi 

    You could just create a measure as below and add it into visual level filter then set filter is > 30.

    To filter = CALCULATE(SUM('Table'[duration]),FILTER(ALLSELECTED('Table'),'Table'[Activity]=MAX('Table'[Activity])))

     

    and here is sample pbix file, please try it.

     

    by the way, you could also use ALL instead of ALLSELECTED in this measure.

     

    Regards,

    Lin

newpi's avatar
newpi
Icon for Helper V rankHelper V
6 years ago

amitchandak This does not seem to work. Also, duration is a measure for me not a column so can't use the sum function and had tried with sumx .

v-lili6-msft's avatar
v-lili6-msft
Icon for Community Support rankCommunity Support
6 years ago

hi newpi 

You could just create a measure as below and add it into visual level filter then set filter is > 30.

To filter = CALCULATE(SUM('Table'[duration]),FILTER(ALLSELECTED('Table'),'Table'[Activity]=MAX('Table'[Activity])))

 

and here is sample pbix file, please try it.

 

by the way, you could also use ALL instead of ALLSELECTED in this measure.

 

Regards,

Lin