Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi all,
I need to devide the current activities from one team with the current margin from the accounts.
For example:
Team "Romandie" have 3.3K activities and accounts with current margin (DB) 853'200.
So 853'200 % 3'300 = x
I've already tried with:
Solved! Go to Solution.
@DaleBrunner , if want to use sum, you need have number, You can use count, distinctcount , min /max on the text. Now if it is number and marked as text, change the data type. or create a new number column using it
SNO = [Serial No]*1
If that has only number this will work
@DaleBrunner , Activities[count activities], is some how is text and a sum operation has been used, can you check that measure andd column and changes its data type. make sure you have not added + "" in measure or some formatting
Thanks @amitchandak for your reply.
Which brings me to my next problem. Subject is not a number, it is only displayed as a number in the table "Count of Subject by team (...)".
I suppose I cannot use the displayed number?
@DaleBrunner , if want to use sum, you need have number, You can use count, distinctcount , min /max on the text. Now if it is number and marked as text, change the data type. or create a new number column using it
SNO = [Serial No]*1
If that has only number this will work
@amitche3 is right - from what I see it looks like you might want to change the SUM to a COUNT
The error message is telling you that you are trying to perform a mathematical function on a string (or text) value. You probably want to double check the "subject" and "new_currentyearddb" are values and then it should work
User | Count |
---|---|
128 | |
108 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |