Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Measure Distinctcount correct on desktop & wrong when published

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, 
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    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. 

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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.