Forum Discussion

New Member

4 years ago

Solved

Calculate distinctcount exclude specific filter

I have a problem which I can't seem to find the answer to. I think the best way to explain the problem I'm having is with an example. So this is an example of the dataset that I have, everything is i...

ValtteriN
4 years ago
Hi,

My first instinct was use REMOVEFILTERS excatly like you suggested and it worked:

I recommend checking the other filters that might affect your table

v-jianboli-msft

Community Support

4 years ago

Hi GeertK ,

Approve with ValtteriN , REMOVEFILTER function works fine in my side.

Here is another measure that may helps you, please try:

Measure = CALCULATE(DISTINCTCOUNT(PartsandQDs[part_id]),FILTER(ALL(PartsandQDs),[Loadpart]=MAX('PartsandQDs'[Loadpart])))

Final output:

Calculate distinctcount exclude specific filter.pbix27 KB

Forum Discussion

Calculate distinctcount exclude specific filter

Related content

How to search specific word in table filter Calculations

Distinctcount, Calculate, y Objetivos

Calculating Days late with specific target times

DISTINCTCOUNT with filters

CALCULATE and DISTINCTCOUNT with condition