Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Dear all,
I would like to create a column that shows for each line of a ticket number the total times this ticket was handled by a support group.
For this, I have three columns:
However, I’m managing to get this result ( tried to use countx, distinctcount).
Would be possible to have you support on this question?
Please, find attached a print with the above mentioned columns.
E.g: the result concerning to group “ZZZ_GTT- AMT – TSC - Content_Deleted” would be 2.
Thank you.
Marcelo
Solved! Go to Solution.
wouldn't it be better to use measure instead of column? that way you could present the correct number in the visuals, with the column it would add 2+2 and show 4 in the Table/Matrix visuals (unless you don't aggregate)
How do you want to present that data in the end?
HI, @datanau001
After my test, you may try this formula as below:
Touching’s per group = CALCULATE(COUNTA('Table'[Audit]),FILTER('Table','Table'[SR_NUMBER]=EARLIER('Table'[SR_NUMBER])&&'Table'[Audit]=EARLIER('Table'[Audit])))
If it is not your case, please share some data sample and expected output. Do mask sensitive data before uploading.
Best Regards,
Lin
HI, @datanau001
After my test, you may try this formula as below:
Touching’s per group = CALCULATE(COUNTA('Table'[Audit]),FILTER('Table','Table'[SR_NUMBER]=EARLIER('Table'[SR_NUMBER])&&'Table'[Audit]=EARLIER('Table'[Audit])))
If it is not your case, please share some data sample and expected output. Do mask sensitive data before uploading.
Best Regards,
Lin
Hello Lin,
Your formula resolved the issue.
Thank for the support.
Marcelo
First a new column and not measure using this formula:
Concatenated_Values = CONCATENATE(CONCATENATE('Table'[Audit Next Owner Group],'Table'[Touchings per group]),'Table'[SR_NUMBER])
Then create a measure to count the values from this new column:
COUNT VALUES = COUNT('Table'[Concatenated_Values])
wouldn't it be better to use measure instead of column? that way you could present the correct number in the visuals, with the column it would add 2+2 and show 4 in the Table/Matrix visuals (unless you don't aggregate)
How do you want to present that data in the end?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
98 | |
78 | |
65 | |
60 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |