Forum Discussion
Counting Uni-char Characters
Hi Experts
Is it possibel to count the number of unichar characters? I am tyring to count the number of X and ticks and X i have against a products. In order to plot the count in a pie chart.
My DAX for unichar
Sure Anonymous - Here is an example (attached PBIX).
Number of Ticks Measure = VAR __Table = SUMMARIZE('DH_AUDITCONTENTIMPORT',[Column1],"__Status",[Status]) RETURN COUNTROWS(FILTER(__Table,[__Status] = UNICHAR(10004)))
11 Replies
Right, so create a measure that SUMMARIZE your data just like in the visual, add a column with your UNICHAR characters and then use COUNTX or COUNTROWS and FILTER to count the number rows of interest.
Sure Anonymous - Here is an example (attached PBIX).
Number of Ticks Measure = VAR __Table = SUMMARIZE('DH_AUDITCONTENTIMPORT',[Column1],"__Status",[Status]) RETURN COUNTROWS(FILTER(__Table,[__Status] = UNICHAR(10004)))
Anonymous
refer :https://community.powerbi.com/t5/Desktop/UNICHAR-Green-Up-arrow-and-Red-Down-arrow/td-p/367804
https://community.powerbi.com/t5/Desktop/UNICHAR-Green-Up-arrow-and-Red-Down-arrow/td-p/367804
In new release you have an option for icon in Matrix under conditional formatting
