Forum Discussion
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])) i...
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.
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.