DISTINCTCOUNT is giving wrong count in grand total

[rock_stage_user]

MeasureTest = CALCULATE(DISTINCTCOUNT(new_processor_info[issuer_id]),FILTER(new_processor_info,new_processor_info[Excluding data from agencies and Mastercard Employees]=TRUE()))

following is my measure but its giving wrong count is there any way to calculate distinct

if you see count total is 21 but it showing 15

[Greg_Deckler]

@rock_stage_user First, please vote for this idea: https://ideas.powerbi.com/ideas/idea/?ideaid=082203f1-594f-4ba7-ac87-bb91096c742e

This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907

Also: https://youtu.be/uXRriTN0cfY
And: https://youtu.be/n4TYhF2ARe8

[rock_stage_user]

from above link i am not getting anything

[rock_stage_user]

Thanks for reply but it will be helpfull to reply related to my query.

MeasureTest = CALCULATE(DISTINCTCOUNT(new_processor_info[issuer_id]),FILTER(new_processor_info,new_processor_info[Excluding data from agencies and Mastercard Employees]=TRUE()))

Measure is showing wrong sum of the values 

[Greg_Deckler]

@rock_stage_user It's a measure total problem. You have to SUMMARIZE the data just like it is in the visual and then use an X aggregator like SUMX, like this:

Measure Test Total =
  VAR __Table = SUMMARIZE('Table',[Processor Name],"__Value",[MeasureTest])
  VAR __Result = IF(HASONEVALUE('Table'[Processor Name]),[MeasureTest],SUMX(__Table,[__Value]))
RETURN __Result

If you don't want to have to do this kind of silliness, please vote: https://ideas.powerbi.com/ideas/idea/?ideaid=082203f1-594f-4ba7-ac87-bb91096c742e

[rock_stage_user]

Thanks,

Measure Test Total =

VAR __Table = SUMMARIZE(new_processor_info,new_processor_info[issuer_id],"__Value",[MeasureTest])

VAR __Result = IF(HASONEVALUE(new_processor_info[issuer_id]),[MeasureTest],SUMX(__Table,[__Value]))

RETURN __Result

but still the same total its giving is there anything we miss its giving 15