Measure Distinctcount correct on desktop & wrong when published

[ratri]

Hi, 

i have following formula to calculate the number of visits: 

CALCULATE(DISTINCTCOUNT(CRM[Vorgänge]);FILTER('Aktivität CRM_9';'Aktivität CRM_9'[Bezeichnung]="Besuch");all(Team_6[Team])) 

in the desktop version the calculation is correct, I can see per customer either 4 or 6 visits per year. However, whne I publish the data, then I see only 1 per customer. So the measure is no more calculated. 

What could be the issue for it? I have other similar measures, f.e. quantity of orders, but there such an issue is not appearing. 

Deleting the measure and create a new one, did not help. 

Thanks! 

Regards, 

[ratri · Accepted solution]

Just found out the issue. 

Reason was that the query changed the text format to decimal numbers. I converted it back to text format again. 

After I deleted in the query the step for decimal number conversion and kept the format for column "Vorgänge"  as text. The issue was solved.