Forum Discussion

mjmt1994's avatar
mjmt1994
Frequent Visitor
7 years ago
Solved

Ignore slicer selection with DAX

Hello all,   I have a page where I use different table visualization/slicer combination to display a series of performance measures for my company. One slicer interacts with one and only one table ...
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    Hi mjmt1994

    Please look at my test for example

    Create measures

    per is the percentage for each row
per = DIVIDE(MAX([value]),MAX([total]))

average per is the average percentage as you expected,
average per = SUMX(ALLEXCEPT(Sheet2,Sheet2[category]),[per])/
                  CALCULATE(DISTINCTCOUNT(Sheet2[flag]),ALL(Sheet2))

     

    The final table should not be filtered by any slicer on the page.

     

    Best Regards

    Maggie

v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi mjmt1994

I make test, is my understanding right?

 

Best Regards

Maggie

 

mjmt1994's avatar
mjmt1994
Frequent Visitor
7 years ago

Hi,

 

Thanks for the quick response!

 

That's basically it, yes.

 

Is there a solution for it?

 

Kind Regards