Forum Discussion

Mussaka's avatar
Mussaka
Helper I
3 years ago

FILTER

Here's my problem; I have a table at the bottom of the picture with one row for each employee; each employee has a total number of hours, a threshold, and the difference between the threshold and the...
Need Help
v-yueyunzh-msft's avatar
v-yueyunzh-msft
Community Support
3 years ago

Hi , Mussaka 

According to your description, you want to get the  distinctcount should not update based on the filtered category.

If this , i think you need to use the removefilters function. And you can  try to use the ALL() with CALCULATE() function to ignore the "category" filter.

For this , you can refer to :
Solved: Exclude applied filters with ALL() - Microsoft Power BI Community

ALL function (DAX) - DAX | Microsoft Learn

The (ALL, ALLSELECTED & ALLEXCEPT) Code - Microsoft Power BI Community

 

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

 

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Mussaka's avatar
Mussaka
Helper I
3 years ago

Leaving aside the fact that the distinct count should not be updated based on the filtered category (perhaps I have found an alternative solution), what measure should I apply so that the percentage ratio between the headcount resulting from filtering by membership group and the total headcount of employees in the table appears in a new tab? (i.e., the one represented as "HC with OT>0" in the image you sent me)? Thank you for your help.