distinct count ignoring all filters applied

[Reddypk]

Hi I have 2 datasets 

1. Excel: this has specific list of sponsor names and specific time frame with their work status

2. Excel: all sponsors + all works they have done 

Work: step 1 - I filtered for work in progress in excel 1 and filtered out all sponsor names whose work status is work in progress 

           Step 2 - for the above list of sponsors (from step one), i need total number of works done irrespective of filters and this is coming from Excel sheet 2 

Issue: when i plot a table, BI is going back and getting only data for specific dates mentioned in excel 1 but i need all works done by him from excel 2

[v-cgao-msft]

Hi @Reddypk ,

Please try like:

distinct count =
VAR _sponsor =
    MAX ( 'Table1'[sponsor names] )
VAR _distcount =
    CALCULATE (
        DISTINCTCOUNT ( 'Table2'[works] ),
        FILTER ( ALL ( 'Table2' ), 'Table2'[sponsor names] = _sponsor )
    )
RETURN
    _distcount

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data